bash - How to get the first column of every line from a CSV file?

Question

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.

question from:https://stackoverflow.com/questions/11668621/how-to-get-the-first-column-of-every-line-from-a-csv-file

Answer 1

Try this:

 awk -F"," '{print $1}' data.txt

It will split each input line in the file data.txt into different fields based on , character (as specified with the -F) and print the first field (column) to stdout.