09-16-2008
converting a .txt file to comma delimeted file
Dear all,
I have a file with 5L records. one of the record in the file is as shown below.
MARIA THOMAS
BASIL
1000 FM 1111 MD
GHANA
YY 77354 4774
99999999 1234567
I need to convert this record in below format
"","","","","MARIA","THOMAS","BASIL","","1000 FM 1111 MD","STE B","","","GHANA","YY","77354","4774",""1234567"99999999"
,"","","","","","","","","","","",""
Please suggest....Thanks in advance.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Can anyone let me know on how to convert a Tab delimited file to Comma delimited file in Unix
Thanks!! (22 Replies)
Discussion started by: charan81
22 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I have already read a lot of posts on sending attachments in unix...but none of them were of help for my problem...so here goes..
i wanna attach a text file and send to a mail id..used the following code :
uuencode "$File1" "$File1" ;|mail -s "$Mail_sub" abc@abc.com
it works... (2 Replies)
Discussion started by: ash22
2 Replies
3. Shell Programming and Scripting
Dear all,
I have a file with 5L records. one of the record in the file is as shown below.
MARIA THOMAS
BASIL
1000 FM 1111 MD
GHANA
YY 77354 4774
99999999 1234567
I need to convert this record in below format
"","","","","MARIA","THOMAS","BASIL","","1000 FM 1111 MD","STE... (1 Reply)
Discussion started by: OSD
1 Replies
4. Shell Programming and Scripting
I need to convert an excel file into a text file
and an excel file into a CSV file..
any code to do that is appreciated
thanks (6 Replies)
Discussion started by: bandar007
6 Replies
5. UNIX for Dummies Questions & Answers
Hi,
Using rsync, I've sent the output to a text file. This is the text file :
Pls help me on converting this text file to a csv file. Probably a script or sth to convert the text file to a csv file. (3 Replies)
Discussion started by: anaigini45
3 Replies
6. Shell Programming and Scripting
Hi,
I came across a very good script to convert a comma seperated to pipe delimited file in this forum. the script serves most of the requirement but looks like it does not handle embedded double quotes and commas i.e if the input is like
1234, "value","first,second", "LDC5"monitor",... (15 Replies)
Discussion started by: anijan
15 Replies
7. Shell Programming and Scripting
HI All,
I have a text file memory.txt which has following values.
Average: 822387 7346605 89.93 288845 4176593 2044589 51883 2.47 7600
i want to convert this file in csv format and i am using following command to do it.
sed s/_/\./g <... (3 Replies)
Discussion started by: mkashif
3 Replies
8. Shell Programming and Scripting
Hi All,
I have a text file with below content.
TradeDate Name SecurityMnc ReasonDesc
=======================================
20120501 Robin ABC FO System Defect
20120502 Robin ABC FO System Defect
I would want this in an excel file in 4 columns,... (3 Replies)
Discussion started by: robinbannis
3 Replies
9. Shell Programming and Scripting
Hello folks
I have a txt file of information about journal articles from different fields. I need to convert this information into a format that is easier for computers to manipulate for some research that I'm doing on how articles are cited. The file has some header information and then details... (8 Replies)
Discussion started by: ksk
8 Replies
10. Shell Programming and Scripting
In the below awk the output is space delimited, but it should be tab delimited. Did I not add the correct -F and OFS? Thank you :).
The input file are rather large so I did not include them, but they are tab-delimeted files as well.
awk
awk -F'\t' -v OFS='\t' 'FNR==1 { next }
> ... (2 Replies)
Discussion started by: cmccabe
2 Replies
record(1) General Commands Manual record(1)
NAME
record - records *.wav files
SYNOPSIS
record [ options ]
DESCRIPTION
record records *.wav files in CD quality (i.e. 44100 Hz, 16bit, stereo). It has a input level meter, which might be useful for sound trou-
ble shooting (check if the mixer settings ok for recording from the TV card etc.)
OPTIONS
-h display help text
-o file
basename for the output file(s), a number and the .wav extension are added by record. Default is "record".
-i dev mixer control. This should be the one where you can adjust the record level for your audio source. Default is "line". "mic" and
"igain" are good candidates too. Best way to figure is to start your favorite mixer tool and check out which one works ...
-m dev set mixer device. Default is "/dev/mixer".
-d dev set audio device. Default is "/dev/dsp".
-r rate
set sample rate. Default is 44100.
-p sec peak seconds (number of seconds which should be scanned for the volume maximum). This affects both peak level display and level
triggered recording (see below). Default is 1.5 seconds.
record can also be used non-interactive:
-c enable console (non-interactive) mode.
-v be verbose (console mode only).
-t mm:ss
Limit the record time (console mode only). By default record records until stopped by a signal (by typing ^C for example).
-s size
Limit the file size (console mode only). record will continue with a new file once the limit is reached.
-n num Limit the file count (console mode only). record will stop recording after num files.
-l Enable level triggered recording (console mode only) with the default trigger level (1000).
-L level
Enable level triggered recording with the specified trigger level.
If level triggered recording is active, record will start and stop recording depending on the signal strength. Recording will be started
if the signal strength is above the trigger level (1000/32768 => around 3%). Recording will be stopped if the signal is below the trigger
level for some time (1.5 seconds by default, the -p switch changes this).
AUTHOR
Gerd Knorr <kraxel@bytesex.org>
(c) Gerd Knorr record(1)