...compare values in a row of 4-columns, (all numbers...

Answer by Gus
Submitted on 8/26/2004
Rating: Not yet rated	Rate this answer:
I'm not sure if the column headers are in the file or not -- if they are, uncomment the three commented lines below. Otherwise, set the hdr array in the BEGIN clause. { if (NR==1) { # for (i=1; i<5; i++) # hdr[i]=$(i) # } else if (NR ==2) { for (i=1; i<5; i++) max[i]=$(i) } else { for (i=1; i<5; i++) if ($(i) > max[i]) max[i]=$(i) } END { for (i=1; i<5; i++) { len[i]=length(""max[i]) if (length(hdr[i])>len[i]) len[i]=length(hdr[i]) } for (i=1; i<5; i++) printf "%"len[i]"s ", hdr[i] printf "\n" for (i=1; i<5; i++) printf "%"len[i]"s ", max[i] }

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

<< Back to: comp.lang.awk FAQ

[ Home | FAQ-Related Q&As | General Q&As | Answered Questions ]

Question by bksys
Submitted on 12/11/2003
Related FAQ: comp.lang.awk FAQ
Rating:	Rate this question:
How can I compare values in a row of 4-columns, (all numbers and of varied field sizes), and print the field with maximum value under its column header?

Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer: