Help to do up a well formatted report?

khaos83 · 05-18-2009, 04:33 AM

File 1

Code:

Name Number1
Peter 123
John 3
ALONGNAME 5432

File 2

Code:

Name Number2
Peter 987
John 72
ALONGNAME 1

I am trying to combine the 2 reports into a well formatted report. But the irregular letter count is my biggest problem.
I join and awk to put tabs in between but the format is off.

e.g.
Combined report

Code:

Name   Number1    Number2
Peter  123    987
John   3      72
ALONGNAME    5432     1

I wish it to be like this
Combined report

Code:

Name      Number1    Number2
Peter     123        987
John      3          72
ALONGNAME 5432       1

Is there anyway to overcome this?
I can handle how file 1 and 2 is formatted, if that helps in my quest.

Tinkster · 05-18-2009, 05:14 AM

Have a look at awk's printf, specifically the %xx[sd...] semantics,
where xx defines the width of your field (you could also right-justify
your numbers - which is more common).

Code:

awk '{if( $3 ~ /[a-zA-Z]/ ){printf "%-10s%10s%10s\n", $1,$2,$3}else{printf "%-10s%10d%10d\n",$1,$2,$3}}' file

Cheers,
Tink

khaos83 · 05-18-2009, 09:21 PM

Quote:

Originally Posted by Tinkster

Have a look at awk's printf, specifically the %xx[sd...] semantics,
where xx defines the width of your field (you could also right-justify
your numbers - which is more common).

Code:

awk '{if( $3 ~ /[a-zA-Z]/ ){printf "%-10s%10s%10s\n", $1,$2,$3}else{printf "%-10s%10d%10d\n",$1,$2,$3}}' file

Cheers,
Tink

Thanks! That works.
I also made a few changes to fit even better than before.

Tinkster · 05-19-2009, 12:36 AM

Quote:

Originally Posted by khaos83

Thanks! That works.
I also made a few changes to fit even better than before.

Cool - glad I could hint you in the right direction! =}

Cheers,
Tink