View Image

TextPipe is a leading text extraction, conversion and data wrangling tool - an affordable alternative to Altair Monarch and Matillion. Text mine / extract data from mainframe EBCDIC COBOL copybooks, log files, PDF, Word, Excel, HTML, JSON, un/structured data, XML, CSV, Tab and delimited files, and database data sources of any type. Upload Data Historian time-series data to Azure Event Hub or Azure IoT Hub. Automate and version transformations EasyPattern or perl-style regular expression search and replace. Use restrictions to control precisely where changes occur e.g. line or column ranges, XML and HTML tags and attributes, CSV- or tab-delimited fields, lines that match/do not match a pattern etc e.g. find and replace just inside the ALT text of an IMG tag, or columns 20-40 of lines 1-10). Convert files between mainframe and DOS, Macintosh and Unix line-feed formats. TextPipe can be scripted from any language using COM or automated from the command-line. Generate and modify XML, CSV, tab-delimited or fixed width database extracts. User-defined filters can be written in VBScript or JScript. TextPipe comes with an Engine that can be embedded in other applications. Audit logs keep track of the filter lists run, files modified and changes made. More than 200 example filter files are included along with a comprehensive online manual. Winner SIA 'Best Application' award. TextPipe Pro reads COBOL data files and converts them to non-COBOL formats such as CSV, JSON, SQL and Excel. TextPipe recognizes these COBOL data file formats: 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