A unix text reformat

[Ferdi Castro]

Hi Everyone,

I would like to ask you assistance for re my text reformat.

I have fileA with this content

abcde,1,xyz
gjhkl,2,bhy
....
...
qwerty,99,mko

I wanna change all second column in same fixed number of characters (lets say just six digits there fore having leading zeroes for lower numbers) like

abcde,000001,xyz
gjhkl,000001,bhy
....
...
qwerty,000099,mko

Can I use the awk command? if yes kindly share it to me then I'll check it. thanks much.

Ferdi

[Peter Godron · Accepted solution]

Ferdi,

awk -F',' '{printf "%s,%06d,%s\n",$1,$2,$3}' text.lis

[john korterman]

Hi,

you can use e few standard cammands, particularly the features of typeset, e.g.:

#!/usr/bin/sh
typeset -Z6 fup
IFS=","
while read one two three
do
fup="$two"
echo "$one,$fup,$three"
done <./infile

man ksh and check typeset!

regards,
John K.