how to get the header of a csv file and print it as a column using linux?

Question

I am trying to get the header or the first line of a csv file and print it as a column.

file example: test.txt name^lastname^address^zipcode^phonenumber

expected result:

name
lastname
address
zipcode
phonenumber

Siva Praveen · Accepted Answer · 2019-10-01 02:30:19Z

7

Just do this

head -n1 test.txt | tr , '\n'

answered Oct 1, 2019 at 2:30

Siva Praveen

2,34120 silver badges20 bronze badges

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

Comments

pacholik · Accepted Answer · 2015-04-23 15:09:33Z

1

head prints n lines of a file, tr replaces all occurrences of a first char with a second char

head -n1 test.txt | tr '^' '\n'

answered Apr 23, 2015 at 15:09

pacholik

9,0529 gold badges48 silver badges59 bronze badges

Duc Vo · Accepted Answer · 2015-04-23 15:21:22Z

1

Try this:

for i in `cat test.txt`; do
IFS='^'
arr=($i)
for col in "${arr[@]}"; do
    echo "$col"
done
break;
done

answered Apr 23, 2015 at 15:07

Duc Vo

613 bronze badges

awesome!!! it worked. sorry, but is there a way to not include echo "${arr[0,1,2,3,4]} coz the header is really long abt 58 fields.

I edited script to print more fields, hope this helps :)

it worked :) thank you so much. cant vote up coz i dont have enough reputation but u saved my day.