asked on 5/15/2011

Find column content from 30 files

Hi,
i have like 30 files
1001a_test_20110413.csv
1003a_test_20110211.csv
1004_test_20110122.csv and so on

in this file contents are
id firstname lastname email company

i am trying to find file (.csv file) which contains email aa@yahoo.com how can i find it
(As i don't know out of 30 files which file have email aa@yahoo.com)

Thanks,

System Programming Linux OS Dev

Last Comment

Tintin

6/2/2011

ozo

5/15/2011

grep 'aa@yahoo.com' *.csv

Tintin

5/15/2011

grep -il 'aa@yahoo.com' *.csv

Open in new window

sam2929

5/15/2011

ASKER

ok i have some .csv files from april 28 and some from may 14 any quick way to count how many .csv
files we have from from may 14

ASKER CERTIFIED SOLUTION

Tintin

5/15/2011

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

sam2929

5/20/2011

ASKER

i am trying to find all files which have yahho.com records doing
grep -il '%yahoo.com%' *.csv its not giving me results

ozo

5/20/2011

Does the file contain yahho.com or %yahoo.com% ?

sam2929

6/2/2011

ASKER

getting error below
grep -il 'aa.yahoo.com' *_reg.csv
ksh: /usr/bin/grep: 0403-027 The parameter list is too long.

Tintin

6/2/2011

In that case, do

find . -name "*_reg.csv" grep -il 'aa.yahoo.com' {} \;

Open in new window