|
DataPipe 3.6
|
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!
|
|
|
|
Download link |
 |
|
Size |
1034KB |
|
License |
Shareware |
|
Price |
590 |
|
Category |
Programming & Software Development / Database & SQL |
|
Operating System |
Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP |
|
Developer |
DataMystic |
|
|
Related keywords: database, data, search, replace, search and replace, find and replace, advanced search and replace, grep windows, global search and replace, sed search and replace, windows utilities, freeware downloads, grep, grep pattern, egrep, search and replace text, |
| |
|
|
| Top Database & SQL / Software Development programs |
|
|
|
|
|
|
-
4)
BITE SQL Reports 1.01a
SQL reporting software that can be "plugged" into any existing database to add advanced reporting capabilities. You can build reports, and store them in the very same database. View, Print, Save and FTP these reports to pre-define places.
|
|
|
|
|
|
|
|
|
|
|
|
|
| New Database & SQL / Software Development programs |
|
|
-
2)
NET Reports Server PRO 2.0
NET Reports 2.0 Server - a Internet ready application; Fast Query & Report solution for Ms.Sql Server, Oracle, PostGreSql, MySql, Interbase, Firebird, MS. VFP. Sybase, MS. Access; Free client software from http://www.net-reports.net/downloads.html
|
|
|
-
4)
Exportizer Pro 3.7
Exports database tables (DB, DBF, MDB, XLS, GDB, IB, HTML, UDL, TXT, CSV) to clipboard or file (XLS, RTF, XML, HTML, TXT, CSV, DBF). Many options allow full control over output.
|
-
5)
Exportizer 3.7
Exports database (DB, DBF, TXT, CSV, etc.) to clipboard or file (XLS, RTF, XML, HTML, TXT, CSV, DBF). Many options allow full control over output.
|
-
6)
Database Tour Pro 5.3.0.764
Universal database tool with report builder. Viewing, editing, and printing data; building SQL queries; building reports; sorting and filtering; viewing and printing structure; searching and replacing text; importing and exporting data.
|
-
7)
Database Tour 5.3.0.764
Universal database tool. It allows viewing, editing, and printing data, building SQL queries, sorting and filtering, viewing and printing structure, reindexing, searching and replacing text, importing and exporting data.
|
-
8)
DBDocumentor 4.20
Document and report on the SQL objects making up your SQL database. DBDocumentor describes all SQL objects in the database, and includes parameter, result set and data usage listings. Output options include colorized source code and XML.
|
-
9)
TOAD for DB2 UDB 1.0.2.837
Toad® for DB2 UDB is a database development solution that provides productivity features for rapidly creating and executing queries, automating database object management, developing SQL code, and instant access to DB2 expertise.
|
-
10)
TOAD for SQL Server 2.0
Toad for SQL Server leverages Quest Software's database expertise to empower SQL developers and administrators, of varying skill levels, to rapidly create and execute queries, automate database object management and develop SQL code more efficiently.
|
|
|