Support SectionWe are here to provide technical support to our customers. |
Change languageThis menu item allows you to change the display language used by ExcelPipe. To translate ExcelPipe into your language, or to find what translations are available, please visit http://www.datamystic.com/languages.html Start processingIdentical in function to the [Start] button in the lower half of the window. Import Search/Replace ListImports a list of search/replace pairs from Excel (.XLS files), Comma Separated Value (.CSV files) or Tab-delimited (.TAB files) formats. Note: Loading large lists from Excel is very slow - export your list to .CSV or .TAB and then import that instead. You can import Unicode or special character replacements from Excel using this item. Note that some special characters may not display correctly - but the replacement will still occur correctly. The special characters are usually shown as question marks or hollow rectangles. Columns required by the Import process (You can find sample import files in the Documents\DataMystic\ExcelPipe\Samples folder (in .tab, .csv and .xls format)):
Search Location ColumnThis column indicates one or more locations to search. Specify it by ADDING the numbers next to the search locations from the list below - DO NOT ADD A NUMBER MORE THAN ONCE.
e.g. to search inside Cells, Hyperlinks and Shapes, add 1+2+4 giving a column value of 7. To search inside hyperlinks in Headers, add 2+8 giving a column value of 10. Export Search/Replace ListThis option exports all of the search/replace terms in the grid to a new file, in Excel (.XLS files), Comma Separated Value (.CSV files) or Tab-delimited (.TAB files) formats. This is useful if you've modified the search/replace pairs or search options and need to export them back to a file. It's also very handy for prototyping the information required to generate an Import file (see the option above).
|
|