fill a NIL into the blank field

Shell Programming and Scripting
1

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,

2

One of the many ways...

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

Plz try this..

or

4

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

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

Great! work fine

7

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

8

Give a try on thsi..

Output:
45111,40404,peter,NIL,0303403,0,030304,john,NIL,9,0:00,

9

yes...it work!! :slight_smile: