Extract value based on column header from Comma separated file using bash

Question

I want to extract 1st value from a csv for a specific column name using bash. For example, i want to extract first value of column "bb". Columns can be in any order

aa,bb,cc
1,2,3
4,5,6

The output should be 2.

RomanPerekhrest · Accepted Answer · 2018-04-06 13:03:32Z

1

Awk solution:

awk -F',' 'NR == 1{ for(i=1; i<=NF; i++) if ($i == "bb") { pos = i; break } }
           NR == 2{ print $pos; exit }' file.csv

The output:

answered Apr 6, 2018 at 13:03

RomanPerekhrest

93.1k4 gold badges75 silver badges112 bronze badges

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

Comments

Gilles Quénot · Accepted Answer · 2018-04-06 13:15:16Z

0

Use this using csvkit :

csvcut -c 2 file.csv | awk 'NR==2'

Output :

answered Apr 6, 2018 at 13:15

Gilles Quénot

188k43 gold badges232 silver badges229 bronze badges

Collectives™ on Stack Overflow

Extract value based on column header from Comma separated file using bash

2 Answers 2

Comments

Output :

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Output :

Comments

Your Answer

Sign up or log in

Post as a guest

Related