Shell Programming and Scripting

firstname, lastname B200000
.
.
.

<5 spaces>first name, lastname<29 spaces from extreme left>B200000
.
.
.

echo 'firstname,lastname B200000' | nawk -F, '{split($2,a, " "); printf("    %s,%-*s%s\n", $1, 29-length(a[2]),a[1],a[2])}'

 	 not sure what '29 spaces from the extreme left' means, but here's a start:

manual command is working fine, now we will need a loop to take care of all lines in the file, thank you!

while read LINE; do awk '{print $1 $2" "$3}'|awk -F, '{split($2,a, " "); printf("    %s,%-*s%s\n", $1, 29-length(a[2]),a[1],a[2])}'; done < hmm.txt

nawk -F, '{split($2,a, " "); printf("    %s,%-*s%s\n", $1, 29-length(a[2]),a[1],a[2])}' myFile

nawk -F, '{split($2,a, " "); printf("    %s,%-*s%s\n", $1, 29-length($1)-6,a[1],a[2])}' myFile