How to add names to columns of a csv file with awk

Question

I have a .csv file with four columns, lacking the headline. I have to insert a new line with the names for each columns. How can I do this?

jlliagre · Accepted Answer · 2013-10-04 07:59:54Z

1

No need to use awk for this:

(
    printf "label1 label2 label3 label4\n"
    cat file.csv
) > file1.csv

answered Oct 4, 2013 at 7:59

jlliagre

31.1k7 gold badges65 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Isidor Lipsch · Accepted Answer · 2015-06-02 19:36:36Z

0

I'm sure there are more sophisticated approaches, but a very blunt way is to create a header file with:

printf "SNP BP A1 TEST NMISS OR SE L95 U95 STAT P\n" > header

(use names of your column separated by space) and then do

cat header myfile.txt > myfile.withheader.txt

provided that your myfile.txt is also space-separated.

answered Jun 2, 2015 at 19:36

Isidor Lipsch

517 bronze badges