Parsing the first column of a csv file to a new file.
- by S1syphus
Operating System: OSX
Method: From the command line, so using sed, cut, gawk, although preferably no installing modules.
Essentially I am trying to take the first column of a csv file and parse it to a new file.
Example input file
EXAMPLEfoo,60,6
EXAMPLEbar,30,6
EXAMPLE1,60,3
EXAMPLE2,120,6
EXAMPLE3,60,6
EXAMPLE4,30,6
Desire output
EXAMPLEfoo
EXAMPLEbar
EXAMPLE1
EXAMPLE2
EXAMPLE3
EXAMPLE4
So I want the first column.
Here is what I have tried so far:
awk -F"," '{print $1}' in.csv > out.txt
awk -F"," '{for (i=2;i<=NF;i++)}' in.csv > out.txt
awk -F"," 'BEGIN { OFS="," }' '{print $1}' in.csv > out.txt
cat in.csv | cut -d \, -f 1 > out.txt
None seem to work, either they just print the first line or nothing at all, so I would assume it's failing to read line by line.
