Extract certain column from CSV files [closed]

Question

I have a directory with a group of CSV files. All files have the same column headers. I need to extract values in a certain column from all files.

The common part in files names is OCS_mobfwref-oam_d01_2014080*

Provide a sample of the data in the files, to see what the delimiter is, the number of columns, etc... Also, what have you tried so far? — jimm-cl, Aug 7 '14 at 14:12
Hi and welcome to the site. Next time, please give us an example of your input and the output you want. It makes it much easier to understand what you need. — terdon♦, Aug 7 '14 at 20:04

Karlo · Accepted Answer · 2014-08-07 14:12:47Z

up vote 1 down vote accepted

To extract from the 3rd column for example, you can do:

cut -d',' -f3 OCS_mobfwref-oam_d01_2014080*

This only works if there are no un-escaped comma's!

If you want to remove the headers, do:

sed 1d OCS_mobfwref-oam_d01_2014080* | OCS_mobfwref-oam_d01_2014080*

answered Aug 7 '14 at 14:12

Karlo
640414

removing headers isn't working – Mohamed Yasser Aug 7 '14 at 14:25

thanks so much btw – Mohamed Yasser Aug 7 '14 at 14:49

add a comment |

Archemar · Answer 2 · 2014-08-07 14:40:11Z

up vote 2 down vote

the same in awk, with a head in first 2 lines, extracting the third field, assuming filed separator is ',' (comma).

 awk -F, 'NR>2 { print $3 ; }' *.csv

answered Aug 7 '14 at 14:16

Archemar
5,59331333

add a comment |

closed as unclear what you're asking by derobert, Ramesh, Karlson, jasonwryan, Braiam Aug 7 '14 at 21:37