header for a csv file from unix shell script

Question

Have to make a header for a csv file from unix shell script. It should be like below.

"Name","Place","Pincode","officename"

Tried like below. But it is not working

s_header= echo "Name","Place","Pincode","officename"

echo s_header>>filename.csv

Thanks you

Ladislav Rolnik · Accepted Answer · 2020-06-09 17:15:21Z

7

You can use tool like sed. 1i means insert at first line.

 sed -i -e '1i"Name","Place","Pincode","officename"' filename.csv

answered Jun 9, 2020 at 17:15

Ladislav Rolnik

1764 silver badges13 bronze badges

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

1 Comment

Petryanu · Accepted Answer · 2020-06-22 16:08:49Z

1

Suppose your csv file contents are in details.csv file. You create header.csv file by printing headers into it.You also can probably try below.

echo "Name","Place","Pincode","officename" > header.csv && cat details.csv >> header.csv && mv header.csv details.csv

Steps:

1)Print the headers into file name header.csv

2)Append the contents of the csv file contents(details.csv) into header.csv

3)Rename the header.csv file back to your original file details.csv

answered Jun 22, 2020 at 16:08

Petryanu

1411 silver badge9 bronze badges