How to extract one column of a csv file

bash csv extract
user788171 picture user788171 · Oct 26, 2013 · Viewed 156.5k times · Source

If I have a csv file, is there a quick bash way to print out the contents of only any single column? It is safe to assume that each row has the same number of columns, but each column's content would have different length.

Answer

synthesizerpatel picture synthesizerpatel · Oct 26, 2013

You could use awk for this. Change '$2' to the nth column you want.

awk -F "\"*,\"*" '{print $2}' textfile.csv

Related questions

How to parse a CSV file in Bash?

I'm working on a long Bash script. I want to read cells from a CSV file into Bash variables. I can parse lines and the first column, but not any other column. Here's my code so far: cat myfile.csv|…

Read More
Turning multi-line string into single comma-separated

Let's say I have the following string: something1: +12.0 (some unnecessary trailing data (this must go)) something2: +15.5 (some more unnecessary trailing data) something4: +9.0 (some other unnecessary data) something1: +13.5 (blah blah blah) How do I turn that into simply +12.0,+15.5,+9.0,+13.5 in bash?

Read More
How to get the first column of every line from a CSV file?

How do get the first column of every line in an input CSV file and output to a new file? I am thinking using awk but not sure how.

Read More