UNIX for Dummies Questions & Answers

Hi! Is there a way to append column and row header to a file in awk script.
For example if I have

Code:

Jane   F   39   manager
Carlos M  40   system administrator
Sam    F   20   programmer

and I want it to be

Code:

# name   gend   age   occup
1 Jane     F       39     manager
2 Carlos   M       40     system administrator
3 Sam      F        20     programmer

I just have no ideas...
Thanks in advance

Moderator's Comments:

Please use code tags next time for your code and data.

Code:

$ awk 'BEGIN{printf("%-3s%-8s%-6s%-5s%-20s\n","#","name","gend","age","occup")}{printf("%-3s%-8s%-6s%-5s%-20s\n",NR,$1,$2,$3,$4)}' infile
#  name    gend  age  occup
1  Jane    F     39   manager
2  Carlos  M     40   system
3  Sam     F     20   programmer

Thanks but if it is not a secret where the numbers 3, 8, 6, 5, 20 are taken from in

Code:

{printf("%-3s%-8s%-6s%-5s%-20s\n","#","name","gend","age","occup")}

No secret. If you count the number and the arguments that are following, separated by a comma, you see that the 1st part containing the numbers is defining the layout, and the 2nd part is just filling the data in the "fields".
The minus says it is left aligned, the 3 says the column is 3 characters wide, and the value supplied should be taken as a s which stands for "string".
And so on...
I have just checked how broad the columns of the heading and your input file is and have defined them for the header as well as for every line that will go through awk.
printf works like this in shell, C, awk, ..., very handy for printing formatted

Thanks