DataPipe Database Search Replace

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! Sub filters can identify text subsets such as a range of lines or columns to be operated on without affecting any other text. This makes it easy to only perform a replacement in lines 1 to 10, or in columns 3 to 20. Other sub filters include CSV- or tab-delimited fields, lines that match or do not match a pattern, and search replacements (allowing replacement text to be capitalized etc). DataPipe can be fully automated from the command line. Full audit logs keep track of the filters run and changes made. More than 100 example filter files are included along with a comprehensive user manual. DataPipe fully supports language translations. DataPipe incorporates TextPipe Pro, and you get TextPipe Pro FREE when you buy DataPipe - so you can use it for cleansing text files and database extracts as well!

Changes: New drop down menu item to browse for more filters, as some users were confused about how many filters it showed in this history list.

Minimum requirements: 16MB RAM, 10MB disk space

Operating system: Win2000,Win7 x32,Win7 x64,Win98,WinOther,WinServer,WinVista,WinVista x64,WinXP

Program URL: http://www.datamystic.com/datapipe.html

VENDOR INFORMATION ------------------ If you are a * Shareware distributor * Disk vendor * Web site * CDROM publisher * Magazine * Book publisher * Software bundler * or any other organisation or person you may distribute the Evaluation Editions (*) of all DataMystic programs provided the following conditions are met: 1. You must inform the buyer that they are paying for your service, not for the programs, and that the programs must be purchased if they wish to continue using them after the evaluation period. 2. You must include all original files included with the program, and you must not modify these files in any way. If required, you may add new files of your own. 3. You must let us know by email if you include our software in your collection. We can then keep you informed of the latest version. (*) All programs use the Help\About dialog or the -? Command line parameter to identify an Evaluation Edition. Contact Information =================== Email: mail@datamystic.com (Simon Carter) WWW: http://datamystic.com Fax: +61-3 8610 1234 Any time. Voice: +61-3 9913-0595 (GMT+10 hours) Mail: Simon Carter DataMystic 5 Bond St Mt Waverley Victoria 3149 AUSTRALIA.

This program and the accompanying files and documentation are Copyright (c) 1990- 2009 DataMystic All rights reserved This file contains our end user license. It also explains the terms of the Commercial License where they're different from the Evaluation License.

Read more