DataPipe Database Search Replace

Making corrections in large sized database often turns out to be a hectic affair for the database administrators as it takes hours of labor to find a specific item from the vast content and replace it with correct data. Well, if you also have confronted such a problem and wish to release the burden of this cumbersome task, then try using DataPipe Database Search Replace 3.8. It’s a great utility that aids you in searching and replacing data inside any database, thus helping you in fixing garbage data, changing embedded UNC paths, removing binary characters, correcting capitalization, and even more. The program also lets you extract email address from the contacts database for your CRM campaign. The utility supports command line operation, complete audit logs providing information of filters used with the changes made. It consists of over 100 filter files accompanied by a detailed user manual for aiding users.

With the DataPipe Database Search Replace sports an intuitive interface comprising of easily-negotiable features. For beginning the correction process, first you’d have to define OLE DB/ODBC data source for establishing connection with the database. For example you’ve selected contacts database and want fix capitalization. Now, you’d be shown the entire tables of the database within a drop down list in Query tab, after which you can either choose retrieving data from any table or write SQL query. Choosing any of the data like Customers, press ‘Preview data’ button that displays the relevant data within rows and columns in Original Data tab. Now for correcting Customer Name field, select it and press next to further set filters for transforming and fixing the errors. You can have preview the output after applying the filter. Within the Preview Changes you can even make manual change to any name if required. Press ‘Go’ and the program would make the necessary corrections.

DataPipe Database Search Replace helps you in making changes and corrections in any database, instantly. The utility deserves to be rated with 4.5 points for its excellent functioning and credible and impressive option-set.

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!