DataPipe Database Search Replace 4.0

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 requires you to download 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!

Keywords: database multiple search and replace, database multiple find and replace, database search and replace program, database find and replace program

Click to enlarge

Author:

DataMystic     Other programs by DataMystic

Downloads:

437

Size:

14353K

Cost:

$495.00 US

Users Rating:

    Reviews (0)     Write review

Feedback:

Report broken download     Report spyware [?]

License:

Shareware [?]

Operating Systems:

Release Status:

update (2015-02-02)

Recent 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.

Supported Languages:

English, Chinese, ChineseSimplified, ChineseTraditional, Polish, Russian

Additional Requirements:

16MB RAM, 10MB disk space

Altova MapForce Enterprise Edition
Altova MapForce is a graphical data mapping, integration, and ETL tool.

Advanced ETL Processor 32 Bit
Extract, transform, validate and load data into ANY database

Database Tour
Universal database tool

Database Browser Portable
This Easy to use tool allows user to connect to any database and browse it.

Database Tour Pro
Universal database tool with built-in report builder

Altova DatabaseSpy Enterprise Edition
Altova DatabaseSpy is the unique query, design, and conversion tool.

Exportizer Pro
Database export tool

Exportizer
Free database export tool

Visual Importer ETL Standard 32 Bit
Extract, transform and load data into ANY Database from ANY Database or file

RazorSQL
SQL database query tool, browser, and editor that supports all major databases

Altova MapForce Professional Edition
Altova DatabaseSpy Enterprise Edition
TextPipe Pro
Events Management Software
dbForge Data Compare for MySQL
dbForge Query Builder for MySQL
dbForge Schema Compare for MySQL
RazorSQL
Visual Importer ETL Enterprise 32 Bit
Database Browser Portable

Altova MapForce Professional Edition (1322 dl.)
Advanced ETL Processor Professional 32 Bit (1293 dl.)
Advanced ETL Processor Enterprise 32 Bit (1291 dl.)
DTM Data Generator (1235 dl.)
Visual Importer ETL Professional 32 Bit (1221 dl.)
Visual Importer ETL Enterprise 32 Bit (1214 dl.)
DTM Schema Reporter (1203 dl.)
Universal SQL Editor (1193 dl.)
Catalog Organizer Deluxe (1150 dl.)
DataNumen Database Recovery (1146 dl.)