DataPipe Database Search Replace 3.8

Program ID:

4908

Author:

DataMystic     All programs by this author

Downloads:

43

License:

Shareware

Cost:

$495.00 US

Operating Systems:

Size:

8157K

Release Status:

update

Last Updated:

2009-10-22

Our Rating:

Feedback:

Report broken download     Report spyware [?]

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

Recent Changes: Now includes TextPipe Pro

Install Support: Install and Uninstall

Supported Languages: English, Chinese, ChineseSimplified, ChineseTraditional, Polish, Russian

Additional Requirements: 16MB RAM, 10MB disk space

TextPipe Pro 8.4.5   (2009-11-20)   update
Industrial strength text transformation workbench for data conversion and mining

DBF to XML 2.15   (2009-11-20)   update
Allows you to convert your dbf files to XML (Extensible Markup Language) format

BB DOALL 6.77   (2009-11-19)   update
View/Edit/Manage .dbf files w/graphing, user customizable interface.

BB EAP 5.58   (2009-11-19)   update
Employee Assistance Program/Case Management/Drug and Alcohol counseling system

DBF to XLS (Excel) 2.15   (2009-11-19)   update
Allows you to convert your dbf files to XLS (Microsoft Excel) format.

DBF Manager 2.3   (2009-11-18)   update
Manage DBF files easily using this innovative tool! Free trial version available

DBF Converter 2.40   (2009-11-17)   update
Convert DBF into XLS, CSV, XML, HTML, RTF, SQL and more. Filter data with ease.

Universal SQL Editor 1.2.0.1   (2009-11-16)   update
Intellisense enabled SQL editor for Oracle, DB2, SQL Server, Sybsae, etc.

DBF to DBF 2.15   (2009-11-16)   update
Allows you to convert your dbf files from one format to another.

SQLWriter 2.3.0   (2009-11-15)   update
SQLWriter is a powerful SQL script editor for almost all kinds of Database