A Database Tool by DataMystic

Seven Reasons Why TextPipe is Different
1 - TextPipe is exceptionally fast. Several unique algorithms speed up processing
2 - TextPipe handles files of unlimited size, even files larger than 2 Gigabytes! Other applications attempt to load the entire file into memory (grinding your system to a halt).
3 - TextPipe's unique restrictions control precisely where changes are made. Restrict to a range of lines or columns, to specific Tab or CSV fields, between HTML/XML tags, and inside custom ranges. Restrictions can be combined, for example, to columns 1-10 of lines matching a pattern. Restrictions are essential for extensive but controlled search and replace
4 -TextPipe performs multiple operations simultaneously. Other applications offer only 1, up to 5, or require a slow multi-pass approach
5 - If TextPipe's 100+ filters don't suit your needs, you can use industry standard VBScript/JScript to write your own. Other applications either don't offer this facility, or force you to learn a proprietary language
6 - TextPipe is unique in offering the EasyPattern pattern matching language for those not familiar with text pattern matching (regular expressions). EasyPatterns are English-like and very easy to learn
7 - TextPipe can be scheduled for non-interactive use, and can be controlled by an external program. Other applications provide only a mouse interface.

TextPipe Users Include:
- Business Analysts (BAs)
- Database Administrators (DBAs)
- Web Site Designers and Authors
- Developers

TextPipe Industries Include:
- Banking and Finance
- Database Consulting/Systems Integrators/High Tech
- Mail houses/Print and Publishing

TextPipe Customers Include:
- Bank of America
- NASA
- US Department of Energy

TextPipe will save you time, frustration and money. It will fix text data, regardless of the number of changes required, the size or number of files, and the complexity of the transformations.

It is trusted by over 1500 customers in 56 countries to
- Convert Huge Files Quickly and Easily
- Data Mine Unstructured Mainframe Reports and Online Web Data
- Cleanse and Reformat Electronic Text
- Update Web Sites
- Data Warehouse ETL Processes
- Extract from Databases to XML, CSV, Tab
- Split and Join Huge Files
- Convert Between a Variety of Mainframe, PC and Unicode Data Formats
- and 1001 other uses.

TextPipe provides a single point of maintenance for all your text processing tasks. You learn one tool, rather than learning 4 or more - and their associated languages, command line options, debugging schemes, idiosyncrasies and operating system differences and dependencies. TextPipe is far less costly to learn, use, develop with and maintain than cobbling together multiple generic tools and custom scripts to achieve one end. It's a Swiss army knife combining the best of perl, awk, grep, sed, and many other less common text processing tools. You'll be productive with TextPipe in minutes, not days.

TextPipe's unmatched power comes from its arsenal of 100+ manipulation filters, its unique architecture and its tremendous flexibility in combining these filters to suit each task. Intuitive line, column, field, tag and attribute restrictions make fixing data extracts simple. You can extract and then modify data from databases, in delimited, XML and SQL Insert Script formats. You can roll your own custom filters using industry standard VBScript and JScript. With TextPipe you can create your own conversions, and deploy them for execution at remote sites. A single click merges files (even those larger than 10 GB), another click extracts emails addresses, and another click sorts and removes duplicates. Try doing that with less than 100 lines of code, in less than 10 seconds!

In a recent speed trial, TextPipe made 17 million replacements in a 250,000 record, 75 MB file in 1:45 seconds. Other 'popular' text applications took 35 minutes and 72 minutes, and MS Word took over 3 hours.