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

DataPipe Ranking & Summary

DataPipe Tags

searcher database replace search database advanced search advanced search and replace cyberscrub paltalk for mac bearshare mac gom player for ilivid for mac ares galaxy for norton partition recovery quicktime mp4 decoder nimbuzz pc windows quake 4 pak003.pk albatross line codeco ringtone plugin for free grand theft

DataPipe Description

DataPipe is an useful and easy-to-use application that manage to perform search and replace actions inside databases. It can fix garbage data, remove binary characters and change embedded UNC paths that are coded in your database. DataPipe interactively fixes development, test or production data in any table. You can correct capitalization in people's names, 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. You can also 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. Main features: Renowned search and replace with pattern matching, sounds-like and fuzzy matching (for fixing up common typing errors) VBScript or JScript (or PerlScript, PythonScript, REXXscript etc) filters can define custom processing for each field Convert end-of-line characters between Unix, Mainframe, DOS and Macintosh formats Correct capitalization (eg sImon -> Simon) Remove unwanted binary characters Remove blanks from the start, end and remove multiple white space Remove HTML Add line numbers, left and right margins, headers and footers Add or remove columns of text or extra lines Pad fields out to width, or truncate them to a width Extract email addresses

DataPipe Related Software