Plain and simple, TextPipe is the most powerful text conversion, transformation, and re-purposing software money can buy – and you'll be productive with TextPipe in minutes, not days.

TextPipe helps data-wranglers, data scientists, and data analytics professionals extract, transform and load (ETL) data from anywhere. Transform data on the fly and discover new levels of speed, simplicity, scale, and savings. Extract data from PDF, Word documents, Excel sheets, Databases of any type, single and multi-segment Mainframe EBCDIC files with Cobol copybooks, and text files of any size and type, including CSV, Tab, XML, HTML, JSON, log files and structured and unstructured reports of any size or dimension. Transform data with 145 Unicode conversions, redaction filters to mask or remove sensitive data such as SSNs, credit cards etc or PII data such as names and addresses.

Use TextPipe to transfer mainframe data to your cloud targets for Big Data, Analytics, Business Intelligence, ERP, CRM, or for application modernization or mainframe offload initiatives.

Connect ALL your data sources - Easily load all your source data into Amazon Redshift, Amazon Aurora or read data from S3 or EFx file systems.

Perform Complex Data Transformations - Perform simple to complex transformations to prepare your data for consumption by leading data analytics tools, including Amazon QuickSight.

Automate and Accelerate your Data Analytics - Job scheduling, version control, logging, automation from CLI and scripting languages, debugging facilities and multi-core utilization to automate and scale your ETL workflows.

A unique system of restrictions control precisely where changes are made. For example, you can apply a lookup table or search/replace to just one column of a huge CSV file. Similarly, you can apply CaSe changes to text within HTML/XML tags or attributes, or even to all text NOT matching a pattern. The combinations are endless. You can also extract data from databases in XML, JSON, CSV and other formats, and post-process it, including pushing it into other databases, or even into Azure Event Hubs and IoT Hubs.

And it’s FAST! For a recent customer, TextPipe applied 603,000 different search/replaces against a 48 MB file in under 30 seconds! By design, TextPipe handles documents of any size with no slowdown, such as Excel CSV files with more than 65535 rows. It can also process compressed files in-situ, such as zip files, website log files, Microsoft Office 2007+ files, OpenOffice files and more.

If TextPipe's 100+ filters or 380 demo files don't suit your needs, you can roll your own using VBScript/Jscript.

As well as traditional perl-style pattern pattern matching, TextPipe offers the intuitive EasyPattern pattern matching language for beginners. For automated use, TextPipe can be scheduled via the command line or controlled from any programming language using COM. TextPipe Server can also take advantage of multiple processors.

You can take a look at this video to see TextPipe in action.

Also, TextPipe was recently updated to version 12, the trial run area can now display columnar data in grid form for easy comparison, and mainframe data natively

After you purchase TextPipe, it may be used for 12 months.