fill a NIL into the blank field

happyv · #1 (**permalink**) 03-23-2007

Hello,

I have a record which split with "," I would like to check..if the field is empty and it will field "NIL" into the field.

input

45111,40404,peter,,0303403,0,030304,john,,9,0,

output

45111,40404,peter,NIL,0303403,0,030304,john,NIL,9,0,

vino · #2 (**permalink**) 03-23-2007

One of the many ways...

Code:

echo "45111,40404,peter,,0303403,0,030304,john,,9,0," | sed -e "s/,,/,NIL,/g"

dennis.jacob · #3 (**permalink**) 03-23-2007

Plz try this..

Quote:

data='45111,40404,peter,,0303403,0,030304,john,,9,0,'
echo $data | sed 's/,,/,NIL,/g'

or

Quote:

echo ${data//,,/,NIL,}

happyv · #4 (**permalink**) 03-23-2007

Quote:

Originally Posted by jacoden

Plz try this..

or

but you echo one record.....ONLY
I have a file which over 100,000 record and I would to fill all records like this format...any idea

anbu23 · #5 (**permalink**) 03-23-2007

Quote:

Originally Posted by happyv

but you echo one record.....ONLY
I have a file which over 100,000 record and I would to fill all records like this format...any idea

Code:

sed -e "s/,,/,NIL,/g" file > tmp
mv tmp file

happyv · #6 (**permalink**) 03-23-2007

Quote:

Originally Posted by anbu23

Code:

sed -e "s/,,/,NIL,/g" file > tmp
mv tmp file

Great! work fine

happyv · #7 (**permalink**) 03-23-2007

also, how can i check the specify field (such as field no#11 and the value is "0", than change to "0:00")?

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Fill the Key fields : Please help us	charandevu	Shell Programming and Scripting	11	04-08-2008 09:40 AM
Fixed length (Fill out)	peterk	Shell Programming and Scripting	3	09-28-2007 11:04 AM
Esc key/Auto-fill	mr_manny	SUN Solaris	3	10-30-2005 07:12 PM
how to include field separator if there are blank fields?	ReV	Shell Programming and Scripting	19	07-13-2005 04:50 AM
awk: How to check if field is blank?	yongho	Shell Programming and Scripting	7	06-09-2005 11:35 AM

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