Replacing the last field of a line.

Darek · #1 (**permalink**) 08-18-2005

Hi,
I wrote a script which extracts data from 2 tables (joining the tables together) and outputs the fields to a csv file.

the output may look something like

scenario 1: a,b,c,d,1,2,3,4 or
scenario 2: a,b,c,d,,,,

now, in the second scenario, there are some empty fields at the end of the line. Basically what I need to do is insert a "0" in the last field if it comes back empty after the database extraction, and i'm not sure how I can do this.

Any help?

thanks,

jim mcnamara · #2 (**permalink**) 08-18-2005

One way:
file:

Code:

a,b,c,d,,,,
a,b,c,d,1,2,3,4

output

Code:

 
a,b,c,d,,,,0
a,b,c,d,1,2,3,4

code

Code:

awk ' {
    if(substr($0,length($0))==",")
    {   print $0 "0"	}
    else
    {   print $0 }
    }'  filename

Ygor · #3 (**permalink**) 08-18-2005

Another way...

Code:

sed 's/,$/,0/' file1 > file2

Darek · #4 (**permalink**) 08-19-2005

Thanks a lot...that did the job.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Replacing a string in nth line	maxmave	Shell Programming and Scripting	1	06-04-2008 06:32 PM
need help with replacing a certain field...	shennanigan83	Shell Programming and Scripting	5	04-09-2008 02:00 AM
replacing a nul field with text	DarkHound	Shell Programming and Scripting	3	09-04-2007 03:34 PM
Replacing more than 1 pattern in a line	Manan	Shell Programming and Scripting	6	12-28-2006 01:58 AM
Replacing certain field	charbel	Shell Programming and Scripting	1	04-26-2006 05:00 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:


	Powered by