DataPipe Database Search Replace 4.0

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!

DataPipe Database Search Replace 4.0
Publisher: DataMystic
License: Shareware
Size: 14.0 MB
Downloads: 1511
Price: $495.00
   
5
Platforms:  Windows2003 , Windows2000 , Windows Vista Ultimate , Windows Vista Starter , Windows Vista Home Premium , Windows Vista Home Basic , Windows Vista Enterprise , Windows Vista Business , Windows , WinXP , WinNT 4.x , WinNT 3.x , WinME , Win98 , Win95
System Requirements:  16MB RAM, 10MB disk space


Latest Downloads from DataMystic

ExcelPipe Find and Replace for Excel 7.8 Download ExcelPipe Find and Replace for Excel 7.8

ExcelPipe Find and Replace for Excel 7.8

Batch Search and Replace multiple Excel spreadsheets. ExcelPipe makes search/replace tasks with Microsoft .xls .xlsx simple.

Change...

WordPipe Search and Replace for Word 9.5 Download WordPipe Search and Replace for Word 9.5

WordPipe Search and Replace for Word 9.5

Search and Replace multiple Microsoft Word documents. Change hyperlinks and UNC paths when servers get renamed; update contact details such as...

TextPipe Pro 10.7.2 Download TextPipe Pro 10.7.2

TextPipe Pro 10.7.2

Slam-dunk the most challenging edit tasks with TextPipe Pro - a powerful text-processing workbench that combines 300+ conversion, transformation,...

TextPipe Engine 10.7 Download TextPipe Engine 10.7

TextPipe Engine 10.7

Slam-dunk the most challenging edit tasks with TextPipe Engine - a powerful text-processing engine that combines 100+ conversion, translation and...

TextPipe Lite 10.7 Download TextPipe Lite 10.7

TextPipe Lite 10.7

TextPipe is the ultimate Webmaster tool for updating text. It handles an unlimited number of files and folders, and is unique in handling files of...

TextPipe Standard 10.7 Download TextPipe Standard 10.7

TextPipe Standard 10.7

Slam-dunk the most challenging code or website edit tasks with TextPipe - a powerful text-processing utility that combines 300+ conversion,...

PredictBGL Diabetes Manager 1.7.3 Download PredictBGL Diabetes Manager 1.7.3

PredictBGL Diabetes Manager 1.7.3

PredictBGL is a beautiful insulin dose calculator that predicts Hypos and blood sugar levels hours ahead.

PredictBGL dramatically...

PowerPointPipe Replace for PowerPoint 5.2 Download PowerPointPipe Replace for PowerPoint 5.2

PowerPointPipe Replace for PowerPoint 5.2

Search and Replace multiple Microsoft PowerPoint presentations. Change hyperlinks and UNC paths when servers get renamed; update contact details...



Popular Downloads

EMS SQL Manager 2005 Lite for SQL Server 2.3 Download EMS SQL Manager 2005 Lite for SQL Server 2.3

EMS SQL Manager 2005 Lite for SQL Server 2.3

EMS SQL Manager Lite for SQL Server is a light and easy-to-use freeware graphical tool for MS SQL/MSDE administration. It has minimal required set...

Smart Database Viewer(Access,Excel,Oracle) 1.5 Download Smart Database Viewer(Access,Excel,Oracle) 1.5

Smart Database Viewer(Access,Excel,Oracle) 1.5

Smart Database Viewer has features which helps you to become mobile with your database. On your Microsoft windows based SmartPhone view MS Access,...

DBF Converter 3.95 Download DBF Converter 3.95

DBF Converter 3.95

dBase, FoxPro and their Windows clones, Delphi applications and more all rely on
DBF files. Modern business realities make high demands for...

IBAdm for Linux 1.0 Download IBAdm for Linux 1.0

IBAdm for Linux 1.0

IBAdm - Interabase/Firebird console administrative tool for Linux. This is console application, compiled by use gcc v3.2 and ncurses v5.0 Uses own...

SmartBook Basic 1.0 Download SmartBook Basic 1.0

SmartBook Basic 1.0

SmartBook Basic is a simple, straightforward tool to help you organize your contacts. It runs on Microsoft Access 2000, Access 2002 (XP), or Access...

1888 Quick Flow Chart Creator 1 Download 1888 Quick Flow Chart Creator 1

1888 Quick Flow Chart Creator 1

Free flow chart creator with all the symbols required in flow chart. Draw flow charts and diagrams quickly for your presentation, documents, etc....

DBPut data transfer 3.1.240 Download DBPut data transfer 3.1.240

DBPut data transfer 3.1.240

DBPut data transfer is a creative and flexible software used for converting data between different databases.
The most convenient way of...

Q-Eye QVD/QVX files Editor (64 Bit) 5.0.0.3 Download Q-Eye QVD/QVX files Editor (64 Bit) 5.0.0.3

Q-Eye QVD/QVX files Editor (64 Bit) 5.0.0.3

Freeware QlikView QVD/QVX files editor

Edit both QVD and QVX Files, Save as QVD, QVX, XML, Excel and SQL Insert Scripts,...

View additional Database Management downloads at 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 ... 108


New Downloads

Altova DatabaseSpy Professional Edition 2019 Download Altova DatabaseSpy Professional Edition 2019

Altova DatabaseSpy Professional Edition 2019

Altova DatabaseSpy Professional Edition is the unique multi-database data management, query, design, compare, and convert tool from the creators of...

Benetl 4.9 Download Benetl 4.9

Benetl 4.9

Benetl is a free ETL tool. It helps to easily manage .csv / .txt / .xls datasource files. With Benetl you can easily extract, transform, and load...

C Pivot for Mac 1.0.3 Download C Pivot for Mac 1.0.3

C Pivot for Mac 1.0.3

C'Pivot is a practice management system, designed for practitioners in coaching, therapy and other disciplines related to complementary and...

C Pivot 1.0.3 Download C Pivot 1.0.3

C Pivot 1.0.3

C'Pivot is a practice management system, designed for practitioners in coaching, therapy and other disciplines related to complementary and...

Altova DatabaseSpy Enterprise Edition 2019 Download Altova DatabaseSpy Enterprise Edition 2019

Altova DatabaseSpy Enterprise Edition 2019

Altova DatabaseSpy Enterprise Edition is the unique multi-database query, design, compare, and convert tool from the creators of XMLSpy....

Altova MapForce Professional Edition 2019 Download Altova MapForce Professional Edition 2019

Altova MapForce Professional Edition 2019

Altova MapForce Professional Edition is a graphical data mapping tool for transforming between XML, database, and flat file formats. This...

DataNumen SQL Recovery 3.2 Download DataNumen SQL Recovery 3.2

DataNumen SQL Recovery 3.2

DataNumen SQL Recovery (DSR) is a powerful tool to repair and recover corrupt SQL Server MDF database files. It can scan the MDF files and...

SQLRD SSRS Data Driven Automation 7.4.20180926 Download SQLRD SSRS Data Driven Automation 7.4.20180926

SQLRD SSRS Data Driven Automation 7.4.20180926

Data Driven & Automated SSRS Reports with SQL-RD

SQL-RD is a dynamic, flexible, function-rich & intuitive automation tool for...