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!
Oracle Find and Replace Software 7.0
Search for and replace data (characters) in your Oracle database tables. You decide which tables to make replacements in. ...
MS SQL Server Find and Replace Software 7.0
Search for and replace data (characters) in your MS SQL Server 2000 or 2005 database tables. You decide which tables to make replacements in. ...
FoxPro Remove (Delete, Replace) Text, Spaces & Characters From Fields Software 7.0
Quickly clear out text, characters, spaces, enters and tabs from fields in FoxPro using different methods. Features include: Remove / Replace All Spaces in Fields, Remove Extra Spaces at Beginning of Fields, Remove Extra Spaces at End of Fields, Remove ...
SQL Populator 1.0
Do you need to replace some strings in your database using the whole power of your favorite text editor? Maybe you would like to make a copy of an existing table with a different name? Need to change an id for some records? Or maybe you simply need a ...
Djuggler Enterprise 2.0.7
Data Juggler automates repetitive Web & data tasks without programming code.The easy-to-use drag-and-drop interface enables you to create automation scripts for combining data from databases, flat files, XML, HTML, Excel, Access, etc.When you configured ...
TextDB 5.16
. TextDB is a high performance search engine with plenty of features to cover all your needsAdd full-text search to your applications by using TextDB's easy-to-use ActiveX components in Visual Basic, ASP or any other ActiveX containerBuild scalable high ...
DTM SQL editor 2.02.99
Set of powerful database management tools: ODBC support, schema viewer, builder DTM SQL editor is a set of powerful database management tools that allow you to achieve two goals: to have unified access to different types of databases and to have a set of solutions that makes processing your data easy.
DTM SQL editor gives database ...
FastTextSearch/IB 1.5
Full text search engine for Interbase FastTextSearch/IB is unique solution for the searching textual information in the Interbase database. Indexing an unlimited amount string and textual memo fields. Implements some idea from text retrivial systems - stop-word list, word stemming. Server ...
ADO Explorer 2.00
ADO Explorer is a powerful database tool using ADO (ActiveX Database Objects) that allows you to proceed quickly and efficiently in your everyday database work.Now comes with ready to use native SQL commands for MSSQL, ORACLE and INFORMIX servers!Features:- ...
Thesaurus Database 1.0
This database contains 2, 520, 265 Keyed words and phrases for use as a Thesaurus. Search for a word, you will find an associated Key value in the database. All other related words or phrases that would be found in a Thesaurus will have the same Key value ...
