Search and replace inside databases. Fix garbage data,
remove binary characters, change embedded UNC paths
coded in your database.

DataPipe interactively or automatically
search/replaces data in ANY table. You can correct
capitalization in people's names (a solution to the
old problem), standardize formatting of addresses (eg
PO Box, P.O. Box, POBOX), extract email addresses (for
your next CRM campaign), search and replace using
advanced pattern matching, fuzzy matching and sounds-
like matching (multiple search and replace operations
occur in a single pass through the database), trim
blanks and multiple whitespace, remove binary
characters ("garbage" characters), remove HTML, XML
and SGML, convert between ASCII and EBCDIC, OEM and
ANSI, Unicode and ANSI, insert or remove text within a
column, force text to a specified width, write your
own VBScript or JScript (or PerlScript, PythonScript,
REXXscript etc) code against columns (and access COM
objects) and MUCH more!

Download (1034 KB) Website Link to this page