Page 1 of 1

Creating many filters from a list in Excel

Posted: Sat Mar 25, 2006 4:00 am
by darnold
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.

Posted: Wed Mar 29, 2006 3:41 am
by darnold
It doesn't have to be a excel file. It can be just a csv or other field limited file.

David Arnold

Posted: Thu Mar 30, 2006 9:34 am
by DataMystic Support
Hi David,

Just use
Filters\Replace\Search & Replace list or
Filters\Replace\Import a search&replace list.


Posted: Thu Mar 30, 2006 4:52 pm
by darnold
Should have RTM. Great product, cann't tell you how much time I have saved using this.


David Arnold

Posted: Thu Mar 30, 2006 8:25 pm
by DataMystic Support
Thanks David :-)

New release 7.7 coming out soon.