Creating many filters from a list in Excel

darnold · Post by **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 · Post by **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

Post by **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.

darnold · Post by **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

Post by **DataMystic Support** » Thu Mar 30, 2006 8:25 pm

Thanks David

New release 7.7 coming out soon.