Awk to convert a flat file to CSV file

rkumudha · #1 (**permalink**) 07-10-2008

Hi ,

I have a file with contents as below:

Code:

Contract Cancellation Report UARCNCL 
LOS CODE DATE REAS TYPE AMOUNT AMOUNT LETTER BY
========= ======= ==== ==== ==== ========= ==== ==== 
8174739 7641509 1S NONE CRCD 30-JUN-2008 NPAR N .00 .00 CCAN 
8678696 8091709 1S NONE DDEB 30-JUN-2008 MVD P .00 .00 LOVES1 
8198258 7663210 1S NONE GIRO 30-JUN-2008 NPAR N .00 .00 CCAN

With the above text, i have two requirements:
1) remove the lines that end with UARCNCL, remove the lines that start with LOS.
2) In rest of the lines, the fields should be comma separated and written to a new file.

the new file should be like:

Code:

8174739,7641509,1S,NONE,CRCD,30-JUN-2008,NPAR,N,.00,.00,CCAN 
8678696,8091709,1S,NONE,DDEB,30-JUN-2008,MVD,P,.00,.00,LOVES1 
8198258,7663210,1S,NONE,GIRO,30-JUN-2008,NPAR,N,.00,.00,CCAN

I'am new to AWK and read through some stuufs in net and wrote a small script( but it did not work)

Code:

awk '{if ($4 != 'UARCNCL') print $1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12}' new > new1

Please correct me on the above script or please advice me on how shall i get the two rewuirements done.

Thanks in advance.

Thanks,
kumudha

ranjithpr · #2 (**permalink**) 07-10-2008

Code:

$ cat csv.awk
{
  if($NF=="UARCNCL" || $1=="LOS" || $1=="=========") next;
  gsub(" ",",");
  print
}

$ cat test.txt
Contract Cancellation Report UARCNCL 
LOS CODE DATE REAS TYPE AMOUNT AMOUNT LETTER BY
========= ======= ==== ==== ==== ========= ==== ==== 
8174739 7641509 1S NONE CRCD 30-JUN-2008 NPAR N .00 .00 CCAN
8678696 8091709 1S NONE DDEB 30-JUN-2008 MVD P .00 .00 LOVES1
8198258 7663210 1S NONE GIRO 30-JUN-2008 NPAR N .00 .00 CCAN

$ awk -f csv.awk test.txt
8174739,7641509,1S,NONE,CRCD,30-JUN-2008,NPAR,N,.00,.00,CCAN
8678696,8091709,1S,NONE,DDEB,30-JUN-2008,MVD,P,.00,.00,LOVES1
8198258,7663210,1S,NONE,GIRO,30-JUN-2008,NPAR,N,.00,.00,CCAN

rkumudha · #3 (**permalink**) 07-10-2008

thanks Ranjith!

But when i run the awk, i get the syntax error at line 3, please help me

Franklin52 · #4 (**permalink**) 07-10-2008

Code:

awk 'NR < 4{next}{gsub(" ",",");print}' file > newfile

With sed it should be something like:

Code:

sed -e '1,3d' -e 's/ /,/g'  file > newfile

Regards

Diabolist · #5 (**permalink**) 07-11-2008

Code:

egrep -v "UARCNCL$|^LOS|^===" inputfile |sed -e 's/ /,/g'

danmero · #6 (**permalink**) 07-11-2008

Or try:

Code:

awk '! /^LOS|UARCNCL$/{gsub(" ",",");print}' file

Annihilannic · #7 (**permalink**) 07-17-2008

The input data you have pasted doesn't appear to match what you have described.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Convert XML file into TEXT file using PERL seript	Rudro	Shell Programming and Scripting	0	06-11-2008 10:03 AM
how to convert Fixed length file to delimited file.	satyam_sat	Shell Programming and Scripting	7	04-03-2008 02:41 AM
Need help to convert Flat file to HTML	getdpg	Shell Programming and Scripting	11	12-20-2006 02:09 AM
Plz Help To convert xml file to text file using bourn shell scripts	ram2s2001	Shell Programming and Scripting	0	11-09-2005 09:56 AM
Converting Pivot file to flat file	vskr72	Shell Programming and Scripting	2	10-18-2005 04:41 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread: