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!
Fraser Stream Integration a powerful data transformation tool that rapidly transforms structured ASCII text reports and delimited files into various file formats.
FSI can convert any text report and:
Translate report data from any source (Windows, UNIX, or Linux) into C
tmWorks R-View tmWorks R-View is a full featured web based database administration and database driven application building tool for the JDBC enabled databases, such as mysql, sql server, oracle etc.
Tools for Excel Tables Essential tools for data analysis and tables management for novice and advanced Excel's users. A set of tools that will strengthen your Microsoft Excel to manage data bases and huge tables in your spreadsheets.
dbConstructor Smart multiplatform Database design tool for software developers, web designer and DBAs. Speed up database developtment and create better databases with dbConstructor.
Adivo TechWriter for Databases Automated Database Documentation! Adivo TechWriter for Databases is the fast and easy way to generate accurate and professional looking documentation for Access, SAS, SQL Server and Oracle databases.
Version: 5.0 Released: Aug, 23 2016 License: Shareware, $495.00 Expires: Expires after 30 Days
File size: 34,761 K Platforms: Windows Vista/XP/ME/NT/2000/98/95 Downloads: 10
Advanced interactive search replace directly in database tables with patterns, fuzzy and sounds-like matching,trim leading and trailing blanks and binary characters,correct capitalization,code your own transform in VBScript or JScript and heaps more