topic Re: Adding column in Operating System - Linux

Adding column

Panpalia — Thu, 19 Jun 2008 09:54:40 GMT

i have the file in below format.
0364120000013502000117186270*805
0323120000013502200115594152*805
0438120000013502400107398174*805
0364120000013502500106634595*805

i need the o/p file
03641200000135*02000117186270*805
03231200000135*02200115594152*805
04381200000135*02400107398174*805
03641200000135*02500106634595*805

I tried sed command but unable to do it.

Thanks in Advanced.

Re: Adding column

James R. Ferguson — Thu, 19 Jun 2008 10:49:37 GMT

Hi:

One way:

# perl -pe 's/(.{13})/$1\*/' file

...and if you want to update in-place do:

# perl -pi -e 's/(.{13})/$1\*/' file

Note that Perl counts from zero, so the fisrt column is 0.

Regards!

...JRF...

Re: Adding column

James R. Ferguson — Thu, 19 Jun 2008 10:58:18 GMT

Hi (again):

Oops, I can't count:

# perl -pe 's/(.{14})/$1\*/' file

# perl -pi -e 's/(.{14})/$1\*/' file

...to update inplace

(or):

sed -e 's/$.\{14\}$/\1\*/' file

...as the firt Perl's counterpart.

Regards!

...JRF...

Re: Adding column

Laurent Menase — Thu, 19 Jun 2008 11:06:13 GMT

while read a b c
do
e=${b#???}
eval "f=${b%$e}"
echo $a $f\*$e
done fileout

or

awk '{printf("%s %s*%s\n", $1, substr($2,1,3),substr($2,4)) }' fileout

of if it is always 135
while read a b c
do
e=${b#135}
echo $a 135\*$e
done fileout

Re: Adding column

Steven Schweda — Thu, 19 Jun 2008 12:24:35 GMT

td192> cat n.dat
0364120000013502000117186270*805
0323120000013502200115594152*805
0438120000013502400107398174*805
0364120000013502500106634595*805

td192> < n.dat sed -e 's/^$..............$/\1*/'
03641200000135*02000117186270*805
03231200000135*02200115594152*805
04381200000135*02400107398174*805
03641200000135*02500106634595*805

Re: Adding column

Panpalia — Thu, 19 Jun 2008 12:49:36 GMT

The sed command (sed -e 's/$.\{14\}$/\1\*/' file) is working fine.

Now how to remove the added * from Outfile to get initial file

Re: Adding column

Steven Schweda — Thu, 19 Jun 2008 12:56:18 GMT

> Now how to remove [...]

Hire someone who can read "man sed" (and
think)?

Re: Adding column

James R. Ferguson — Thu, 19 Jun 2008 12:58:56 GMT

Hi (again):

> The sed command (sed -e 's/$.\{14\}$/\1\*/' file) is working fine.

> Now how to remove the added * from Outfile to get initial file

Then:

# sed -e 's/\*//' file

Regards!

...JRF...

Re: Adding column

Panpalia — Fri, 20 Jun 2008 10:16:02 GMT

Thanks!