replacing spaces with null or 0 in the input file

trichyselva · #1 (**permalink**) 01-06-2009

hi
i have records in my input file like this

aaa|1234||2bc||rahul|tamilnadu
bba|2234||b4c||bajaj|tamilnadu

what i am expecting is in between two pipes if there is no character it should be replaced with null or 0

so my file will look like this

aaa|1234|null|2bc|0|rahul|tamilnadu
bba|2234|null|b4c|0|bajaj|tamilnadu

how to do it

can anyone explain

thanks in advance

jaduks · #2 (**permalink**) 01-06-2009

Code:

$ cat tri.txt
aaa|1234||2bc||rahul|tamilnadu
bba|2234||b4c||bajaj|tamilnadu

$ awk 'BEGIN{OFS=FS="|"}{ for(k=0;k<=NF;k++)
if ( $k == "" )
$k="NULL"
print $0}' tri.txt

aaa|1234|NULL|2bc|NULL|rahul|tamilnadu
bba|2234|NULL|b4c|NULL|bajaj|tamilnadu

cfajohnson · #3 (**permalink**) 01-06-2009

Code:

sed -e 's/||/|null|/g' -e 's/||/|null|/g' FILE

trichyselva · #4 (**permalink**) 01-06-2009

thanks a lot it worked
but i wanted null and 0 to be populated
is there any way for the same

thanks in advance

summer_cherry · #5 (**permalink**) 01-06-2009

Code:

#! /usr/bin/perl
open FH,"<a.txt";
while(<FH>){
	my @tmp=split("[|]",$_);
	map{$_=$_||"null"} @tmp;
	print join "|",@tmp;
}

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Replacing the Spaces	Amey Joshi	UNIX for Dummies Questions & Answers	3	11-11-2008 11:15 PM
need help in replacing spaces in a file	sais	Shell Programming and Scripting	7	10-06-2008 09:24 AM
Replacing character in file with null value	HLee1981	Shell Programming and Scripting	18	07-18-2006 01:33 PM
Handling null input...	DrRo183	Shell Programming and Scripting	2	04-11-2006 01:32 AM
finding & replacing blank rows/spaces in a file	Gerry405	SUN Solaris	2	07-21-2005 04:49 AM

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