Hi folks, I am trying to convert one character to a numeric format,
for example :
" 1" to number 1
:cool:
Ups forgot to tell you .. !!! I am trying to do it with kornshell !!!
;) (4 Replies)
I have some text data generated by a perl script and want to put it into an excel sheet. Is there a perl script that can do this for me, i.e, convert text data to excel? (1 Reply)
hi all,
i have a select query that gives me the output in the following way...
SYSTYPE
--------------------------------------------------------------------------------
Success Failures Total RFT
---------- ---------- ---------- ----------
TYP
1 0 ... (3 Replies)
Hello Gurus,
I have a text file containing nearly 12,000 tab delimited characters with 4000 rows. If the file size is small, excel can convert the text into coloumns. However, the file that I have is very big. Can some body help me in solving this problem?
The input file example,
... (6 Replies)
Hello,
I have a text file(utf8-bom). I want convert to following format. Thank you.
1***hello 35345
29***hello test6
380***bill33
4327***hello test6
47829***hull55
65644***hello test6
I want this format.
1***hello 35345
29***hello test6
380***bill33
4327***hello test6 2... (8 Replies)
Hi Gurus
I need urgent help to convert a flat log file into csv format to load into database.
Log looks like:
a=1
b=2
c=3
a=4
b=5
c=6
Only the values at right side of = will come into csv and it should create a new line once it receives "a" field. (8 Replies)
Hi Team,
I have created a script to output DB Query data to a text file. It displays output as follows for 2 different queries appended to same file.
I want help to convert this data to xls format so that the output of first query is in 1 tab and the other in second tab. Please help.
... (14 Replies)
Hi,
Is there somebody there to post an idea on how to convert this 5 liner row to 1 liner or tab delimiter to be import to database.
Here the text file format:
Description: Description1
Link: https://www.google.com
Date: June 2, 2018
Time: 00:07:44
Age: 1 days ago
Description:... (2 Replies)
Hi.
I need an input file of a single word pr. line converted in into a list of random pairs.
i need input like this
word1
word2
word3
word4
to be outputted like this:
word3 word1
word2 word4
My attempt is a tedious while loop like this:
nfiles=$(cat inputfile | wc -l) ... (4 Replies)