Exact Replace

The following Wizards are available to help design your text processing task:

For TextPipe Web, Standard and Pro

• Convert end of line (EOL) characters from one Operating System (PC/Mac/Unix) format to another
• Search and replace a string with another

• Search and replace a pattern with another

• Restrict a search and replace to a line range, a column range or both
• Add line numbers
• Remove blank lines and white space
• Email cleanup - remove e-mail reply marks, clean up word and sentence spacing etc
• Convert between Tab Delimited, Comma Delimited, Semi-Colon Delimited and Pipe Delimited formats
• Extract text between delimiters

For TextPipe Standard and Pro

• Process website logs - remove or retain lines matching a pattern
• Split files
  • Split a file or files so that they fit on a floppy disk
  • Split a file or files after a given number of lines
  • Split a file or files whenever a given character appears
• Join or merge files
  • Join files together
  • Join files together and then sort them
• Sort files, even files larger than your machine's memory
• Convert EBCDIC to ASCII
• CSV (Comma Separated Value) files
  • Remove CSV fields - see Filters\Remove\CSV fields
  • Move CSV fields
  • Copy CSV fields
  • Search and replace inside a CSV field
  • Manipulate a range of CSV fields
• Tab delimited files
  • Remove Tab-delimited fields
  • Move Tab-delimited fields
  • Copy Tab-delimited fields
  • Search and replace inside a Tab-delimited field
  • Manipulate a range of Tab-delimited fields

For TextPipe Pro

• Extract email addresses
• Extract data from a database
• Program a custom task in VBScript, JScript or other scripting languages

Other Resources

• Latest wizards (online)
• User-contributed wizards (online)
• Contribute your own wizard (online)
• Suggest a new wizard (online)
• Download TextPipe Pro
• Feature comparison chart between the Web, Standard and Pro editions (online)
• TextPipe's COM interface (Advanced) (online)

Notes

You must have the latest version of TextPipe installed to use this wizard. Please download it from www.datamystic.com. This wizard does not work with TextPipe for askSam.

If you use IE6 or later, you might have to customize your security settings to use the online version of this wizard (as opposed to the local version installed when you download TextPipe).

If you get a dialog like this, just click 'Yes'.

To fix the security settings, go to Internet Explorer's Tools Menu\Internet Options, Security tab, click on Trusted Sites, click on Sites button, add 'http://www.datamystic.com' to the list.