With DataPipe there is NO need to export and then import your data after changing it. DataPipe applies TextPipe filters to each column of data you specify, so whatever you can do with TextPipe you can also do to a column of data in your database.
e.g. Search and Replace (with prompting and pattern matching), Capitalization, Encryption, change Character set encodings, your own custom JScript/VBScript and much more.
Every database contains some degree of invalid or incorrect data, usually because of operator error or programming errors. These errors can prevent normal processing of the data, can cause searches for the records to fail, and invalid data formatting can cause mail-merges of the data to look very unprofessional.
DataPipe includes TextPipe Pro, and applies its amazing text processing capabilities to data in your database. TextPipe provides a huge range of filters for manipulating text. DataPipe's unmatched power comes from TextPipe's unique architecture and combining and arranging it's filters to suit each task. TextPipe can be run both standalone and within DataPipe.
Process Data From Anywhere
Lightning Fast Search and Replace
DataPipe offers the fastest and most powerful search and replaces:
The replacement text can include all or part of the original text or a re-arrangement of it, and the case of the replacement text can be automatically altered to preserve the case of the original text. The replacement text can also be modified by any combination of filters such as by converting it to Upper Case, performing further search and replaces inside the replacement text or even a database or dictionary lookup.
Manipulate Precise Sections of Text
DataPipe can manipulate specific portions of the text rather than the entire text, such as Line Ranges, Column Ranges, Lines Matching a Pattern and Lines Not Matching a Pattern. You can combine sections together, for example, to alter a specific line and column range. You can also apply further text manipulations to the Replaced Text in a Search and Replace operation, such as by making the Replacement Text UPPERCASE.
DataPipe's enterprise features include:
DataPipe makes it easy to connect to Customer Relationship Management (CRM) tools like GoldMine, Onyx, Siebel, Great Elk, ACT!, Eipiphany and more.
Check out the powerful functions listed below:
Some of Our Clients
DataPipe is used by Aspect Computing, IMS, UC Davis Medical Center, City of Winnipeg, Trucking2Go, Harrington Industrial Plastics, Trane, United Nations, Intelli-Source, Suramericana de Seguros SA, Johnson & Johnson, East Tennessee Computers, Saskatchewan Learning and many other large organisations.
DataPipe comes in both Single User and Site licenses:
Multi-user, Site and Enterprise licenses are also available to enhance the efficiency of your entire team.
DataPipe is the
only database application where you can interactively search and
replace through records in your database
DataPipe's pattern matching AND replacing allows you to rearrange the text in a field e.g. swapping surnames and first names
And DataPipe provides all this without the need for custom programming, however, ...
...If you need to perform custom processing, DataPipe allows you to write your own filters in industry standard VBScript, JScript or a variety of other scripting languages.
If you have trouble setting up transformations yourself, why not pay one of our data transformation consultants to do it for you?
|AcidFiles.com, Jul 2005|
|CriticalFiles.com, Jun 2005|
|Byte-Flow.com, Jun 2005|
|SoftChecker.com, Jun 2005|
|Editor’s pick, their highest award (Jan 2003)|
Try DataPipe today!