Shell Script help for Quotation Delimited File

I need help extracting a column in a file separated by quotations. I would like to extract the first column of data and write it to a flat text file. EXAMPLE of data:

"c6e181396a1100ba19c53a6757a845c4","2012-05-18","email"
"70879000563753bb9051b4ab8df43ac4","2012-05-18","email"
"8dc50039efcb069cc0a9c40cc9015068","2012-05-18","email"
"9a0ce897cdb52a18fa5c76e3309def16","2012-05-20","email"

Any help would be greatly appreciated.

Nick :wall:

awk -F, '{print $1}' infile > outfile
cut -d , -f 1 infile > outfile

excellent! worked perfect. Another step. How may I take out the quotes?

awk -F\" '{print $2}' infile > outfile

OR

cut -d \" -f 2 infile > outfile

Try piping it through the tr command:

tr -d '"'

wow great! Thanks for the help. All fixed up! :slight_smile: