Search Results

Hi right_coaster,

Try:


$ cat file1
PRODCON1|SYSTEM.IOA|040720101327|USER1|201004071327
PRODCON2|SYSTEM.TEST|040720101327|USER1|201110010932
SA|SYSTEM.CCR|040720101327|USER1|201004071327...

sed 's/[.][0-9]*$//' myFile

Tiny correction (assuming the alignment is to be maintained)...

sed 's/^0/ /' File


Or removed:

sed 's/^[0 ]//' File


If you want to remove multiple leading zeros:

sed 's/^0[0]*/ /'...

sed 's/^0//' File

nawk -F'@' 'FNR==NR{f2[$1]=$2;next} {print $1, (($1 in f2)?f2[$1]:"NULL")}' file2 file1