This filter is used to easily define a set of search/replace pairs that have identical search options.

From file

Loads a series of search/replace pairs from a file dynamically at run time. If the file extension is .XLS, the file is assumed to be Excel format, if the extension is .TAB the file is assumed to have tab-delimited values, and any other extension (including .CSV) is assumed to have Comma-Separated Values.

Excel spreadsheet (.xls)

The Excel spreadsheet must have data in Sheet 1, and be formatted with the search term in column A, and the replacement for it in column B. No heading is allowed. The loading process stops when a blank cell is reached in column A. It might look as follows:

Tab-delimited file (.xls)

The list is loaded from a Tab-delimited file. Such a file can be created with Notepad, and looks like this:

a       b
aaaabbb cccccdddd ssss

a       

a
a       b      c
 

CSV-delimited file (.csv or any other extension)

The list is loaded from a CSV-delimited file. Such a file can be created with Notepad, and looks like this:

a,b
"a","b"
"aaaa""bbb","ccccc""dddd""ssss"
a,
a
a,b,c
"a","b","c"
"aaaa""bbb","ccccc""dddd""ssss","sssss""ssss"

Using these values

Use the grid to specify multiple search/replace pairs.

The string, pattern or Sounds like text to find. The string can contain unprintable characters. The right-click (or context) menu on this field supports Undo, Cut, Copy, Paste, Delete, Clear Entire Field, Select All and Select All And Copy, entering special characters and inserting pattern match characters.

Find/Replace options

Find type, Match case etc, as for normal search/replace.

 Contact Us   Support   Community   Tutorials and User Guides (online)
 Copyright © 1999-2006 DataMystic. All rights reserved.