topic Re: Awk print question in Operating System - HP-UX

Awk print question

Belinda Dermody — Tue, 20 Nov 2001 22:00:44 GMT

I have a file that the first 4 fields are variable length and each only have 1 data item/word
FileName Tape#REC# RptName Date and the last field is comments variable length with words. The file is not delimited. I know how to use the printf sequence in awk to format the output for it to look nice, but the last field is comments and could be any number of words or stuff. Is there a way in awk to say use $5, etc ... till the end of the record and print it as one field.

Re: Awk print question

Craig Rants — Tue, 20 Nov 2001 22:25:35 GMT

This may not be exactly what you are looking for but I think it will work. The output will need a little work.

awk '{for (i = NF; i > 4; i--) print $i}'

Good Luck,
C

Re: Awk print question

Marco Paganini — Tue, 20 Nov 2001 22:38:00 GMT

Hello,

This "one-liner" awk program should do the trick for you:

awk '{ rest=""; for (ix = 5; ix <= NF; ix++) { rest = rest " " $ix } printf("%-10.10s %-10.10s %-10.10s %-10.10s %s\n",$1,$2,$3,$4,rest) }'
You may change the %-10.10s format to something that gives you a better aesthetic result.

Hope it helps,
Paga

Re: Awk print question

Sridhar Bhaskarla — Tue, 20 Nov 2001 22:42:49 GMT

James,

Try this way.

If your file is called my_text and the first four fields are fixed (say by "space") then you would do like this

awk '{print substr($0, index($0,$4)) }' my_text

-Sri

Re: Awk print question

Sridhar Bhaskarla — Tue, 20 Nov 2001 23:05:04 GMT

Hi (again),

A small correction. Make it $5 in the above awk statement otherwise it will print $4 + the comments.

-Sri

Re: Awk print question

Belinda Dermody — Wed, 21 Nov 2001 16:41:46 GMT

Thanks for the response, Craigs and Sridhar did not work or provide the output that I was looking for, Marco works great, a long one liner though and I have to change the formating parameters.

Thanks

Re: Awk print question

Sridhar Bhaskarla — Wed, 21 Nov 2001 16:52:48 GMT

James,

Probably it would have helped if you provided a sample input file.

If your input file is like this

testfile 23#1212 test.report 11/12/01 this is ofcourse my comment

Then

awk '{print substr($0, index($0,$5)) }' input_file

will print out

this is ofcourse my comment

It's a very simple logic that we are printing the substring starting from $5 (this) no matter what spaces or characters are there later. You don't have to deal with the formatting.

-Sri