DataPipe 3.6
Search and replace inside databases.
|
Search and replace inside databases. Fix garbage data, remove binary characters, change embedded UNC paths coded in your database.
DataPipe interactively fixes development, test or production 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!
tags search and and replace sub filters textpipe pro and ansi binary characters remove binary you can
Download DataPipe 3.6
Purchase: Buy DataPipe 3.6
Similar software
DataPipe 3.6
Crystal Software
Search and replace inside databases.
TextPipe Standard 12.1
Crystal Software
Update text using search and replace, which supports perl pattern matching, sounds-like matching, edit-distance matching and search/replace lists.
TextPipe Engine 12.0
Crystal Software
Slam-dunk the most challenging edit tasks with TextPipe Engine - a powerful text-processing engine that combines 100+ conversion, translation and filtering operations on multiple text or binary files.
TextPipe Pro 12.1
DataMystic
Slam-dunk the most challenging edit tasks with TextPipe Pro - a powerful text-processing utility that combines 270+ conversion, transformation, extraction and report mining operations on multiple text or binary files.
TextPipe Web 7.8.12
Crystal Software
TextPipe Web is the ultimate Webmaster tool for updating text.
WordPipe Search Replace 5.9.6
Crystal Software
WordPipe Search Replace - make multiple changes to multiple MS Word documents in one pass.
VEDIT 6.13.1
Greenview Data
VEDIT edits any text, data, binary file in ASCII, Hex or EBCDIC; even 100+ Gigabyte files.
ResumePipe 2.9.2
Crystal Software
Converts emails and their attachments to numbered text files suitable for importing into applicant tracking and resume packages such as ResTrac.
LogEdit 0.86
Espen Austad
LogEdit is basically a text-editor with a few enhancements.
FindReplaceExcel 2.15
Roger Adams
FindReplaceExcel is a find/replace tool for Windows to search Excel files for text, values and comments.