topic awk and printf in Operating System - HP-UX

awk and printf

baiju_3 — Fri, 14 Jan 2005 15:51:45 GMT

Hi ,

I am trying to format a log file .I need a aligned 4 column o/p .Sample of the log file is attached.

I am using cat sample.txt |awk -F"|" '{printf "%10s %-20s %20-s %20-s", $1,$2,$3,$4}'

But Its not able to format the o/p in columnvice.

Can you pls help.

Thanks

Re: awk and printf

A. Clay Stephenson — Fri, 14 Jan 2005 16:03:02 GMT

You are close; your main problem is lack of a linefeed ("\n") and a little better printf formatting is needed:

awk -F '|' '{printf("%-10.10s %-20.20s %-20.20s %-20.20s\n",$1,$2,$3,$4)}' sample.txt

Re: awk and printf

baiju_3 — Fri, 14 Jan 2005 16:23:22 GMT

Hi Clay Stephenson ,

\n I was using forgot to type .

It has not given me the required o/p .
Can you please try this on the sample.txt attached.

Thanks,
Baiju.

Re: awk and printf

A. Clay Stephenson — Fri, 14 Jan 2005 16:34:36 GMT

My version works perfectly for me using your input file. I do note that very few of your input lines have all four fields with non-whitespace values. It would help if you list a sample line of input followed by your desired output. You should also note that your attached file had CR's which I assume the original UNIX output did not have.

Re: awk and printf

baiju_3 — Fri, 14 Jan 2005 16:53:21 GMT

Control char might have added during copy paste to ITRC.

The o/p which I was looking for is attached .

Still no progress for me.

Re: awk and printf

A. Clay Stephenson — Fri, 14 Jan 2005 17:37:59 GMT

Well, I have no idea what your problem is but I spent about 4 minutes throwing together a script and tested it against your sample.txt.

Please see the attached file which contains both the script and the output.

After you yank out the script, chmod 777 my.sh and then
my.sh < sample.txt > out.txt

Re: awk and printf

Hein van den Heuvel — Fri, 14 Jan 2005 23:03:14 GMT

You need to eat the spaces somehow.
The can be done with a replace in the 'code',
or they can be sucked into the ERE for the seperator. Try:

awk -F " *[|] *" '{printf "%10s %-20s %-20s %-20s\n", $1,$2,$3,$4}'

The ERE is
- a space followed by an asterix for zero or more spaces.
followed by
- a boxed in |. I had to do this to avoid the bar becoming an 'or'
followed y zero or more spaces.

Cheers,
Hein.