DataPipe Search and Replace: Online Help
    Features
 

Submit feedback on this topic 

 Home  Menus: File   Edit   Options (Logging, Restart & CommitTools   Help   Tabs: Query   Sample data   Transforms   Preview changes   Go

 

DataPipe leverages the amazing text processing abilities of TextPipe Pro with live data in your production database. DataPipe scans through your dataset row by row (minimizing locking problems), enabling full production access without interruption. Best of all, you don't have to extract or dump your data to a file before operating on it - DataPipe connects to your database live!

All the best text processing features of TextPipe Pro are here:

  • Renowned search and replace with pattern matching, sounds-like and fuzzy matching (for fixing up common typing errors)
  • VBScript or JScript (or PerlScript, PythonScript, REXXscript etc) filters can define custom processing for each field
  • Convert end-of-line characters between Unix, Mainframe, DOS and Macintosh formats
  • Correct capitalization (eg sImon -> Simon)
  • Remove unwanted binary characters
  • Remove blanks from the start, end and remove multiple white space
  • Remove HTML
  • Add line numbers, left and right margins, headers and footers
  • Add or remove columns of text or extra lines
  • Pad fields out to width, or truncate them to a width
  • Extract email addresses
  • and much, much more.

DataPipe runs under Windows 95/98/ME/NT/2000/XP.

See also

What is DataPipe?
New features in this release

 Contact Us   |  Support   |  Community
 Copyright © 2001-2006 DataMystic. All rights reserved.