Excel

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

johnhu
Posts: 1
Joined: Fri May 22, 2009 5:48 pm

Excel

Postby johnhu » Fri May 22, 2009 5:53 pm

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

User avatar
DataMystic Support
Site Admin
Posts: 2136
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Excel

Postby DataMystic Support » Tue May 26, 2009 11:25 am

Yes, convert each document to .csv format, then run them through TextPipe using

Filters\Extract\Extract lines matching pattern list
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: Yahoo [Bot] and 1 guest