Parsing the first column of a csv file to a new file.
Posted
by S1syphus
on Stack Overflow
See other posts from Stack Overflow
or by S1syphus
Published on 2010-04-16T11:28:31Z
Indexed on
2010/04/16
11:33 UTC
Read the original article
Hit count: 345
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.
© Stack Overflow or respective owner