Creating many filters from a list in Excel

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

darnold
Posts: 3
Joined: Sat Mar 25, 2006 3:53 am
Location: Chino, CA
Contact:

Creating many filters from a list in Excel

Postby darnold » Sat Mar 25, 2006 4:00 am

I have a Excel spreadsheet of about 600 abbreviations that I need use to expand the product description field in a MSSQL database. I know that I am going to use TextPipe and DataPipe inorder to do this. But, I am look for a way to create the filters without having to retype all the abbreviations and expanded definitions. Is there a way to do this. The individual filters should be just S&R for whole words.

David Arnold
Harrington Industrial Plastics, LLC.

darnold
Posts: 3
Joined: Sat Mar 25, 2006 3:53 am
Location: Chino, CA
Contact:

Postby darnold » Wed Mar 29, 2006 3:41 am

It doesn't have to be a excel file. It can be just a csv or other field limited file.

David Arnold

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

Postby DataMystic Support » Thu Mar 30, 2006 9:34 am

Hi David,

Just use
Filters\Replace\Search & Replace list or
Filters\Replace\Import a search&replace 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

darnold
Posts: 3
Joined: Sat Mar 25, 2006 3:53 am
Location: Chino, CA
Contact:

Thanks

Postby darnold » Thu Mar 30, 2006 4:52 pm

Should have RTM. Great product, cann't tell you how much time I have saved using this.

Thanks.

David Arnold

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

Postby DataMystic Support » Thu Mar 30, 2006 8:25 pm

Thanks David :-)

New release 7.7 coming out soon.
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: No registered users and 1 guest