TextPipe is an affordable and versatile data tool for extracting and converting text, with the capability to mine data from multiple sources including COBOL copybooks, logs, PDF, HTML and JSON. It offers a comprehensive alternative to Matillion and Altair Monarch for text analysis and manipulation.
Moreover, you can upload your Data Historian time-series data to Azure Event Hub or Azure IoT Hub. TextPipe also allows you to automate and version transformations through the use of EasyPattern or perl-style regular expression search and replace. You have the flexibility to use restrictions to control where changes occur precisely. For instance, you can search and replace just inside the ALT text of an IMG tag or columns 20-40 of lines 1-10.
Additionally, TextPipe enables you to convert files between mainframe and DOS, Macintosh, and Unix line-feed formats. You can also script TextPipe from any language using COM or automate it from the command-line. You can generate and modify XML, CSV, tab-delimited or fixed-width database extracts. Moreover, you can write user-defined filters in VBScript or JScript.
TextPipe comes with an Engine that can be embedded in various applications, and its audit logs keep track of the filter lists run, files modified, and changes made. This software also includes more than 200 example filter files and a comprehensive online manual. Furthermore, TextPipe Pro can read COBOL data files and convert them to non-COBOL formats such as CSV, JSON, SQL, and Excel.
TextPipe recognizes several COBOL data file formats, including MF- MicroFocus COBOL, MFSCO- MicroFocus SCO COBOL, MF8- MicroFocus COBOL IDXFORMAT8, VIS- MicroFocus Visual COBOL, RM- RM / RM85 COBOL, FSC- FSC RMKF COBOL, ACU- AcuCOBOL, ACU- Egan iCOBOL, ACU- WANG COBOL, SEQ- Sequential COBOL data files, and your file format. With all these features, it's no surprise that TextPipe won SIA's 'Best Application' award.
Version 11.8:
* Added Redaction filters to replace or mask out sensitive field data such as customer information, medical records, and employee IDs
* Mainframe filter now diagnoses erroneous characters found in packed fields and suggests updated PIC fields
Version 11.7.5:
* New Mainframe Dump filter shows file offsets, EBCDIC hex characters and
ASCII equivalents – making it far easier to debug mainframe file conversions
when the cobol copybook is out of date.
* Fixed memory corruption issue effecting x64 keyed editions.
* Fixed memory issue preventing exit
Version 11.7.1:
* New Mainframe Dump filter shows file offsets, EBCDIC hex characters and ASCII
equivalents - making it far easier to debug mainframe file conversions when
the cobol copybook is out of date.
* Mainframe filters now handle PICTURE
* Mainframe filters now handle OCCURS followed by INDEXED BY
Version 11.6:
* Unicode filter to Remove Diacritics
* Concurrency Improvements
* 2200 HTML5 entity support
* Mainframe EBCDIC improvements
Version 10.8:
* Major UI facelift - super slick interface
* Mainframe copybook filter now identifies COMP-3 before PIC clause.
* Fixed handling of Convert HTML Entities to Text, and updated HTML 4 DTDs to define 252 named entities.
* Split filter now processes macros after the file numbering has taken place.
Version 10.7.2:
* Fixed @inputFile@ truncating last character of filename.
* Updated main memo control to fix intermittent stack overflow issue.
Version 10.7:
* Mainframe copybook now supports JUST RIGHT clause.
* Mainframe copybook now supplies better error message when COMP- types appear
without a PIC clause or length.
* Windows Explorer shell extensions can now be edited.
Version 10.6:
* Field specification filters now support field names with embedded hyphens (-
), and field names with spaces can be used by surrounding them with quotes.
* A warning is now output when a field specification does not match the field
names found in a file.
* Improved error handling for scripting
Version 10.5:
• Added the much-requested JScript/VBScript Scripting Filter to TextPipe x64!
• Updated Unicode compose/decompose functions for NFC, NFD, NFKC, NFKD
• Updated PDF libraries
• Updated code page converter library (2013->2017)
• Updated TextPipe Engine DLL royalty-free embeddable component
Version 10.4:
New high-performance Azure Event Hub connection for JSON data.
New high-speed Azure IoT Hub connection for JSON data.