Please help replace character command

justbow · December 16, 2009, 1:44am

hi i have log :

i want remove some char become like this:

anybody can help me ?

anand_bh · December 16, 2009, 1:52am

cat file | sed "s:'TBCD::g"

justbow · December 16, 2009, 2:00am

i think that command only can remove this 'TBCD
how about this line.. " 0F'TBCD 19 " ??

i mean the column 1 2 3 there are a bit different in the result

Scrutinizer · December 16, 2009, 2:23am

try:

sed "s/\(0F\|F\)\?'TBCD//g" infile

-or-

sed -r "s/(0F|F)?'TBCD//g" infile

justbow · December 16, 2009, 2:31am

how about the "19" in column 3 ??

Scrutinizer · December 16, 2009, 2:38am

cut -c1-15,22-37,44,47-56,61-74 infile

You can also do it with sed but since you need to remove characters at fixed positions cut is the more obvious choice IMO.

sed 's/..TBCD//1;s/...TBCD 19/ /1;s/.TBCD//g' infile

ichigo · December 16, 2009, 4:54am

gawk '{gsub(/\047TBCD/,"");gsub(/^19/,"",$3)}{print}' file

Scrutinizer · December 16, 2009, 4:58am

Have you tried your code and compared the results?