DataMystic

Posted: **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.

Posted: **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

Posted: **Thu Mar 30, 2006 9:34 am**

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**

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

Thanks.

David Arnold

Posted: **Thu Mar 30, 2006 8:25 pm**

Thanks David

New release 7.7 coming out soon.

DataMystic

Creating many filters from a list in Excel

Creating many filters from a list in Excel

Thanks