DataPipe Database Search Replace 3.9

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!

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:

17

Size:

8418K

Cost:

$495.00 US

Users Rating:

    Reviews (0)     Write review

Feedback:

Report broken download     Report spyware [?]

License:

Shareware [?]

Operating Systems:

Release Status:

update (2011-02-24)

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

DBDocumentor
Produce cross referenced and hyperlinked documentation of SQL databases.

Advanced XML Converter
Powerful XML converter quickly turning XML files into HTML, XLS, CSV, SQL, DBF

CDBF for Windows
View, edit and repair the DBF database files, create reports, export data, etc.

Export Table to Excel for SQL Server
Export Table for Microsoft SQL Server helps to save table's data to Excel file

BBAutoHarvest
An EASY to use contact manager/follow-up system for customers, or potential cust

Data Exchange Wizard
Data Exchange Wizard Loads or export data from/into ANY database

Database Oasis
Create custom databases in minutes using point-and-click with Database Oasis.

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

Export Schema to SQL for SQL Server
Creates SQL script for database definitions: tables, views, procedures, keys,etc

FmPro Script Diff
FmPro Script Diff - The external script editor for FileMaker Pro.

ETL-Tools QlikView Connector
Universal SQL Editor
SQLite Developer
Reportizer
Visual Importer ETL Standard
Small Library Organizer Pro
MyDbExplorer
Advanced XLS Converter
FlowHeater
ESF Database Migration Toolkit Standard

EMS Data Import for Oracle (281 dl.)
Business Kit (275 dl.)
Recovery for MySQL (272 dl.)
Vendor Organizer Deluxe (271 dl.)
EMS Data Import for DB2 (266 dl.)
Recovery for FileMaker (265 dl.)
UK Postcodes (264 dl.)
TirePrices (262 dl.)
AzSQL Script Decryptor (262 dl.)
dbForge Studio for MySQL (260 dl.)