How to extract values from a csv file to Unix Shell Script

Question

From a unix shell scripting file, I want to extract the values in a csv file. Suppose, I have a csv file values.csv with headers V1, V2 and N like below:

"V1","V2","N"
"0","0",216856
"1","0",16015
"0","1",25527
"1","1",10967

I want to extract the column N values and assign it to a variable in a unix script file. For example,

How will you pull the values of N and assign to the variables a,b,c,d in a shell script file? Please help. Thanks in advance.

glenn jackman · Accepted Answer · 2018-03-15 20:50:05Z

1

Don't use individual variable names, use an array. Install csvkit, then

mapfile -t n < <(csvcut -c "N" file.csv)

echo "a = ${n[1]}"
echo "b = ${n[2]}"
echo "c = ${n[3]}"
echo "d = ${n[4]}"

Note that CSV can be surprisingly tricky to parse, so use a proper CSV parser.

edited Mar 15, 2018 at 20:50

answered Mar 15, 2018 at 20:44

glenn jackman

249k42 gold badges233 silver badges362 bronze badges

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

Comments

Matias Barrios · Accepted Answer · 2018-03-15 20:48:41Z

0

This will work in Bash, assuming you would want to use arrays, which is the right way to do this :

 array=( $( tail -n +2 values.csv | awk -F',' '{print $3}'  | tr '\n' ' ' ) )
 echo "${array[0]}"

Regards!

answered Mar 15, 2018 at 20:48

Matias Barrios

5,0864 gold badges31 silver badges71 bronze badges

Collectives™ on Stack Overflow

How to extract values from a csv file to Unix Shell Script

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related