DataPipe Database Search Replace 3.9 - Detailed Description Page

Program ID:

24612

Author:

DataMystic     All programs by this author

Downloads:

109

License:

Shareware [?]

Cost:

$495.00 US

Operating Systems:

Size:

8418K

Release Status:

update

Last Updated:

2011-02-24

Our Rating:

Users Rating:

    (total votes: 0)

Feedback:

Report broken download     Report spyware [?]

DataPipe interactively or automatically search replaces data in ANY table. You can correct capitalization in people's names, standardize formatting of addresses, extract email addresses, search and replace using advanced pattern matching, fuzzy and sounds like matching, trim blanks and multiple whitespace, remove binary characters and html, insert or remove text within a column, write your own transform in VBScript or JScript and heaps more!

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 incorporates 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!

Keywords: database multiple search and replace, database multiple find and replace, database search and replace program, database find and replace program, Shareware, Business, Databases & Tools, DataPipe Database Search Replace, DataMystic

Recent Changes: New drop down menu item to browse for more filters, as some users were confused about how many filters it showed in this history list.

Install Support: Install and Uninstall

Supported Languages: English, Chinese, ChineseSimplified, ChineseTraditional, Polish, Russian

Additional Requirements: 16MB RAM, 10MB disk space

DBEXform 4.2.1   (2012-05-22)   update
DBEXform offers easy and efficient way to design forms, reports and charts for Sql databases. The simplest way to make a small database software, is to drag table from database and drop it to a new form in the designer and DBEXform creates editing an...

Resume Manager Pro 3.40.46   (2012-05-20)   update
Find a perfect employee automatically among thousands of applications in a matter of minutes! Save hours of hand work by automating resume processing and management and run complex searches to find an ideal candidate for a specific position. Resume M...

Visual Importer ETL Professional 8.0.3.2   (2012-05-18)   update
Visual Importer Professional automates loading data into ANY Database from ANY Database or file. Plus automation of business processes such as FTP, Email: POP3 and SMTP, File operations, SQL scripts, Zip and Unzip, ETL Task scheduler and comprehensiv...

Reportizer 4.0.2.202   (2012-05-15)   update
Reportizer is a band oriented database reporting tool. It allows easy creating, modifying, and printing database reports from different types of databases connected by ADO or BDE. Report generator of Reportizer supports expressions, grouping, calcula...

Advanced ETL Processor Enterprise 5.3.0.3   (2012-05-15)   update
Build Complex Data warehouses and Automate Entire Business Processes, Transfer Data from ANY Database into ANY Database or file. FTP, Email: POP3 and SMTP, File operations, SQL scripts, Zip and Unzip, ETL Task scheduler and comprehensive logging. Wo...

Advanced ETL Processor Professional 5.3.0.2   (2012-05-15)   update
Advanced ETL Processor Pro transfers data from ANY Database into ANY Database or file. Full automation of business processes such as FTP, Email: POP3 and SMTP, File operations, SQL scripts, Zip and Unzip, ETL Task scheduler and comprehensive logging....

Visual Importer ETL Standard 5.0.0.1   (2012-05-14)   update
Visual Importer loads data into ANY Database from ANY Database or file. Full support for Excel, Access, DBF, XML and Text files, Oracle, MS SQL Server, Interbase/Firebird, MySQL, PostgreSQL, SQLite or any ODBC compliant database. Great performance - ...

Advanced ETL Processor 3.4.2.1   (2012-05-14)   update
Advanced ETL Processor extracts data from any database, transforms, validates it and loads into another database automatically. It can help you extract data from an Excel file, validate date formats, sort data, deduplicate it and load it into any dat...

Visual Importer ETL Enterprise 8.0.3.2   (2012-05-11)   update
Visual Importer Enterprise automates loading data into ANY Database from ANY Database or file. Plus automation of business processes such as FTP, Email: POP3 and SMTP, File operations, SQL scripts, Zip and Unzip, ETL Task scheduler and comprehensive ...

Advanced XLS Converter 2.55   (2012-05-07)   update
Convert Excel XLS files into a variety of formats! Advanced XLS Converter converts Microsoft Excel spreadsheets into DBF, TXT, HTML, XML, CSV, SQL, and RTF formats with just a few clicks. Depending on the destination format, complex formatting, calcu...

SQLite Developer 3.91   (2012-05-04)   update
Sqlite Developer, a powerful database manager that will manage sqlite3 database!features: SQL Editor with autocomplete, unicode support, live sql syntax check, SQL formatter. Unicode Support Data Type Mapping. Execute multiple sql. Query Builder. Vi...

DBmover for MSSQL to Oracle 2.0.1   (2012-05-03)   new
Dbmover for MSSQL to Oracle is a powerful tool to import MSSQL contents into Oracle database. DBMover allows you to define flexible table/field mappings between MSSQL and Oracle databases. It also lets you perform a query and use the query result as ...

Universal SQL Editor 1.3.9.2   (2012-05-02)   update
Universal SQL Editor is a lightweight Intellisense-enabled database query tool. It allows you connect Oracle, DB2, SQL Server, Sybase and any ODBC compliant database, and edit complex SQL with Intellisense-like autocompletion, highlight references, p...

ESF Database Migration Toolkit Standard 7.3.06   (2012-05-01)   update
Enables you to easily transfer data between various database formats in 3 steps without writing any scripts. It can directly connect to Oracle, MySQL, SQL Server, PostgreSQL, IBM DB2, Informix, Teradata, Caché, MS Access, MS Excel, Visual Foxpro, SQL...

ESF Database Migration Toolkit Pro 7.3.06   (2012-05-01)   update
Enables you to easily transfer data between various Database Manager Systems. It can directly connect to Oracle, MySQL, SQL Server, PostgreSQL, IBM DB2, Informix, Teradata, Caché, MS Access, MS Excel, Visual Foxpro, SQLite, FireBird, CSV and other f...

Sonar3 3.0.2.4   (2012-05-01)   update
Sonar is a manuscript submission tracking program. This program tells me which market has each story, whether a story has been sold or rejected and which stories are gathering dust instead of earning their keep. Free software from the author of the H...

ERD Concepts 5.6   (2012-04-30)   update
ERD Concepts is a database designer and sql query tool for all major databases. Create a complete and professional ERD diagram design with tables, foreign keys, views, stored procedures and more. Design and live database access in a consistent user i...

Star Bill of Lading Program 7.86   (2012-04-26)   update
Star BOL program is capable of printing all of your Bill of Lading form requirements to a standard Laser Printer. It saves you Time and Money everytime you use it. No more Expensive Forms to purchase. Get rid of those 10 different programs a...

Exportizer Pro 5.16   (2012-04-24)   update
Exportizer Pro is a database export tool. It allows to export data to database, file, clipboard, or printer. Can export DB, DBF, MDB, ACCDB, XLS, XLSM, XLSB, GDB, IB, FDB, HTML, UDL, DBC, TXT, CSV to text, CSV, XLS, RTF, XML, HTML, DBF, INSERT statem...

Exportizer 5.16   (2012-04-24)   update
Exportizer is a free database export tool. It allows to export open table to file, clipboard, or printer. Can convert DB, DBF, text, CSV to text, CSV, XLS, RTF, XML, HTML, DBF, INSERT statements. Many options ensure full control over output. There ar...

• All
  • All Categories
• Audio & Multimedia
  • Audio Encoders/Decoders
  • Audio File Players
  • Audio File Recorders
  • CD Burners
  • CD Players
  • Multimedia Creation Tools
  • Music Composers
  • Other
  • Presentation Tools
  • Rippers & Converters
  • Speech
  • Video Tools
• Business
  • Accounting & Finance
  • Calculators & Converters
  • Databases & Tools
  • Helpdesk & Remote PC
  • Inventory & Barcoding
  • Investment Tools
  • Math & Scientific Tools
  • Office Suites & Tools
  • Other
  • PIMS & Calendars
  • Project Management
  • Vertical Market Apps
• Communications
  • Chat & Instant Messaging
  • Dial Up & Connection Tools
  • E-Mail Clients
  • E-Mail List Management
  • Fax Tools
  • Newsgroup Clients
  • Other Comms Tools
  • Other E-Mail Tools
  • Pager Tools
  • Telephony
  • Web/Video Cams
• Desktop
  • Clocks & Alarms
  • Cursors & Fonts
  • Icons
  • Other
  • Screen Savers: Art
  • Screen Savers: Cartoons
  • Screen Savers: Nature
  • Screen Savers: Other
  • Screen Savers: People
  • Screen Savers: Science
  • Screen Savers: Seasonal
  • Screen Savers: Vehicles
  • Themes & Wallpaper
• Development
  • Active X
  • Basic, VB, VB DotNet
  • C / C++ / C#
  • Compilers & Interpreters
  • Components & Libraries
  • Debugging
  • Delphi
  • Help Tools
  • Install & Setup
  • Management & Distribution
  • Other
  • Source Editors
• Education
  • Computer
  • Dictionaries
  • Geography
  • Kids
  • Languages
  • Mathematics
  • Other
  • Reference Tools
  • Science
  • Teaching & Training Tools
• Games & Entertainment
  • Action
  • Adventure & Roleplay
  • Arcade
  • Board
  • Card
  • Casino & Gambling
  • Kids
  • Online Gaming
  • Other
  • Puzzle & Word Games
  • Simulation
  • Sports
  • Strategy & War Games
  • Tools & Editors
• Graphic Apps
  • Animation Tools
  • CAD
  • Converters & Optimizers
  • Editors
  • Font Tools
  • Gallery & Cataloging Tools
  • Icon Tools
  • Other
  • Screen Capture
  • Viewers
• Home & Hobby
  • Astrology/Biorhythms/Mystic
  • Astronomy
  • Cataloging
  • Food & Drink
  • Genealogy
  • Health & Nutrition
  • Other
  • Personal Finance
  • Personal Interest
  • Recreation
  • Religion
• Network & Internet
  • Ad Blockers
  • Browser Tools
  • Browsers
  • Download Managers
  • File Sharing/Peer to Peer
  • FTP Clients
  • Network Monitoring
  • Other
  • Remote Computing
  • Search/Lookup Tools
  • Terminal & Telnet Clients
  • Timers & Time Synch
  • Trace & Ping Tools
• Security & Privacy
  • Access Control
  • Anti-Spam & Anti-Spy Tools
  • Anti-Virus Tools
  • Covert Surveillance
  • Encryption Tools
  • Other
  • Password Managers
• Servers
  • Firewall & Proxy Servers
  • FTP Servers
  • Mail Servers
  • News Servers
  • Other Server Applications
  • Telnet Servers
  • Web Servers
• System Utilities
  • Automation Tools
  • Backup & Restore
  • Benchmarking
  • Clipboard Tools
  • File & Disk Management
  • File Compression
  • Launchers & Task Managers
  • Other
  • Printer
  • Registry Tools
  • Shell Tools
  • System Maintenance
  • Text/Document Editors
• Web Development
  • ASP & PHP
  • E-Commerce
  • Flash Tools
  • HTML Tools
  • Java & JavaScript
  • Log Analysers
  • Other
  • Site Administration
  • Wizards & Components
  • XML/CSS Tools