Shell Programming and Scripting

Hi,

I have the following code (I inherited and am new to awk):

nawk -F, '{OFS=","; print $1,$2,"0000"$3" ",$4" PH",$6," PAYROLL HOURS USD ",$5,$7,$8}' /tmp/payfile > /tmp/paywork1


Q: How do I modify this so that if length of $3 = 6 then only pad 00 and if its length = 5 then pad 000 and if its length = 4 then pad 0000 (like original code)

preferrably: an if statement to check on length of $3 and KEEP original line of code because of possible error occur with formatting of input $5, $7, and $8

Thanks!

as suggest in another forum - check your awk's man pages for 'printf' formatting options.

Code:

nawk -F, -v OFS=',' 'length($3) < 8 {$3=sprintf("%08d", $3)} {print $1,$2,$3" ",$4" PH",$6," PAYROLL HOURS USD ",$5,$7,$8}' /tmp/payfile > /tmp/paywork1

Thanks. I did try to look at printf function but some reasons, the inputs $5,$7, and $8 got messed up when they are being used below this line of code. However, the code that you just described seem to work. I am so happy :-)

I don't follow, but ok....

I did try using this equivalent code:
nawk -F, '{printf "%s,%s,%08d ,%s PH,%s, PAYROLL HOURS USD %d,%d,%d\n",$1,$2,$3,$4,$6,$5,$7,$8}' /tmp/payfile > /tmp/paywork1

--input $3 worked in terms of padded 0s to be 8 in length BUT subsequent format for $5,$7,$8 seem to be off.

you're printing them as INTERGERS (%d) whereas in the original 'print' they;re explicitely printed as STRINGS.

Try changing the '%d' to '%s' for $5, $7, $8

Thanks vgersh99 for your help.