Thread: take data from cvs file to stdout, print column headings every 20 lines

Im trying to take data from a cvs file and display column heading names every 20lines or so.

file.cvs | post.sh

Code:

#!/bin/bash


while read y; do
        printf "Year\t%s\Eng. Disp.\t%sCyl.\t%sCity FE\t%sHwy FE\t%sModel" #heading


        awk -F ":" '{printf "%s\t%s\t%s\t%s\t%s\t%s\n", $1, $4, $5, $6, $7, $2}' #data
done

want it to look like
Year Eng. Disp. Cyl. City FE Hwy FE Model
2012 1.5 6 42 45 BMW
2012 1.5 6 42 45 BMW
2012 1.5 6 42 45 BMW
2012 1.5 6 42 45 BMW
2012 1.5 6 42 45 BMW
2012 1.5 6 42 45 BMW
2012 1.5 6 42 45 BMW
2012 1.5 6 42 45 BMW
2012 1.5 6 42 45 BMW
2012 1.5 6 42 45 BMW
2012 1.5 6 42 45 BMW
...

Year Eng. Disp. Cyl. City FE Hwy FE Model
2012 1.5 6 42 45 BMW

hi,

awk can do it alone.

Code:

awk -F ":" 'NR==20 
NR%20==0{print "Year\tEng. Disp.\tCyl.\tCity FE\tHwy FE\tModel"}
{printf("%s\t%s\t%s\t%s\t%s\t%s\n", $1, $4, $5, $6, $7, $2)}' urFile

Originally Posted by Watael

hi,

awk can do it alone.

Code:

awk -F ":" 'NR==20 
NR%20==0{print "Year\tEng. Disp.\tCyl.\tCity FE\tHwy FE\tModel"}
{printf("%s\t%s\t%s\t%s\t%s\t%s\n", $1, $4, $5, $6, $7, $2)}' urFile

Can you also count the number of lines processed? I need to learn more about awk!

And print it out like There where $x number of records processed?

Thanks for the help,
Jason

for every line printed, you increment a variable, and print it whenver you want.

you'll learn awk from its man page, and its user's manual