Page 1 of 1

Excel

Posted: Fri May 22, 2009 5:53 pm
by johnhu
Can someone advise?.

I get an excel spreadsheet every week with approx 10,000 rows and 10 colums of company details.

I have another list of 600 company that I deal with. Is it possible to use the 600 list I have to extract any relevant company rows from the 10,000 spreadsheet?.

Thx,

John

Re: Excel

Posted: Tue May 26, 2009 11:25 am
by DataMystic Support
Yes, convert each document to .csv format, then run them through TextPipe using

Filters\Extract\Extract lines matching pattern list