DataPipe download - Advanced search replace in databases with patterns, fuzzy and sounds like match

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!

DataPipe 3.6
Release date:2006-09-20
File size:1034 KB

RECOMMENDED TOOLS

» database » data » search » replace » search and replace » find and replace » advanced search and replace » grep windows » global search and replace » sed search and replace » windows utilities » freeware downloads » grep » grep pattern » egrep » search and replace text

Altova MapForce Professional Edition 2009     
Altova MapForce Pro is a graphical data mapping tool for XML, DBs, & flat files.
Price: 499$, Rating: 6, Downloads: 1186

DreamCoder for MySQL Enterprise 4.0     
DreamCoder for MySQL is tool for MySQL Database administration and development
Price: 125$, Rating: 10, Downloads: 1185

Advanced Database Recovery 1.0     
Database recovery suite for MS Access MDB databases and DBF databases.
Price: 349.95$, Rating: 10, Downloads: 1184

Export Query to Excel for SQL Server 1.02.00     
Export Query for Microsoft SQL Server helps to save query results to Excel file
Price: 45$, Rating: 5, Downloads: 1183

KeyedAccess for MS Access 3.2     
Lock your MS Access app, require users to enter installation-specific UnlockCode
Price: 299.00$, Rating: 10, Downloads: 1181

EMS DB Extract 2005 for MySQL 2.1     
Utility for creating database backups in a form of SQL scripts.
Price: 95.00$, Rating: 9, Downloads: 1179

MySQL Turbo Manager Free Edition 3.7     
MySQL Turbo Manager is tool for MySQL Database administration and development
Price: 0$, Rating: 8, Downloads: 1179

CDBF for Windows 2.99.02     
View, edit and repair the DBF database files, create reports, export data, etc.
Price: 35$, Rating: 7, Downloads: 1178