Sed will replace empty space with NULL

Question

Using sed

desired output

    |200|0|NULL|0|NULL|NULL|^A|0|NULL|NULL|

+5

Deano Feb 11 '13 at 20:12

4 answers

I think the team you are looking for may be called "tr". Try

tr \\n \\0

+1

mikyra Feb 11 '13 at 20:23

cat file | sed 's/\\N/NULL/g' | awk -F\| '{for(i=2;i<=NF;i++){ if($i==""){ printf "|NULL"} else{  printf "|%s", $i}}; printf "|\n"}'

+1

Anew Feb 11 '13 at 20:25

with awk

awk 'gsub("\\\\N","NULL");gsub("\\|\\|","|NULL|")' temp.txt

0

user2134226 Feb 12 '13 at 1:13

Thor · Accepted Answer · 2013-02-11T20:23:11+0000

You need a slightly modified version of this . Something like this should work:

sed ':a; s:|\(\\N\)\?|:|NULL|:g; ta'