TextConverter 2.2 dramatically simplifies the process of data extraction/conversion from computer generated documents by offering a unique capability of accomplishing the most difficult and time consuming part of the task - identifying the internal document’s structure automatically without programming.

The goal is achieved by employing an artificial intelligence (AI) engine that is capable of recognizing reoccurring patterns of data layout, formatting, and content thus identifying records and fields to be extracted. The tool also provides full support for conventional script-based data parsing and data transformation processing.

TextConverter 2.2 is also a programmable automation component equipped with application programming interfaces (API). It can be integrated into your applications using virtually any programming environment (including scripting engines).

The most effective way of resolving your data extraction task is by using TextConverter 2.2 in combination with our data extraction service, which you can use to submit your task to us and to receive the completed project files ready to be incorporated into your automated environment. The response will be sent to you within 24 hours (usually within a few hours).

TextConverter 2.2 Standard | $600 Input formats: PDF, DOC, RTF, XLS, HTML, CSV, and Txt files Automatically detects patterns that represent record and field structure Accesses multiple data sources VB Script support with proprietary objects and methods for data transformation Preview the output as you work Output: any OLE DB or ODBC compliant database - ORACLE, SQL Server, MySQL, DB2, Access, or generate files for Excel, FoxPro, and more

TextConverter 2.2 Developer | $1,500 Everything in the Standard Edition plus... Programming automation with an API controllable runtime component Royalty free redistribution** **Limited to internal use, special agreement, and non-competing platforms as determined by SiMX at its sole discretion.

FREE conversion setup with product trial Let us solve your data extraction/conversion problem:  1. Submit a sample of your input text file and ... 2. Receive a configured TextConverter project in a few hours (reasonable complexity sample projects with comprehensive specification)

The market offers a variety of text import/conversion tools, which can be generally divided into two groups: dialog-based and programming tools. The dialog-based tools do not require programming skills, but have complicated user interfaces with limited functional flexibility. The programming tools, on the other hand, have virtually unlimited flexibility, but require expensive programming expertise and are time-consuming.

TextConverter offers the best of both worlds: a dialog-based interface, automatic pattern detection, and high-level scripting capabilities.

Extract PDF, XLS, DOC, RTF QIF, OFX, CSV, GPX, Legacy Extracts, etc.

Transform Auto Mode, Detect Tags and Delimiters, VB Script: Split, Combine, Transform, etc.

Load MS SQL Server, ORACLE MySQL, Access, DB2, dBase, CSV, Excel, etc.

Conversion Process

Step 1. Extract - Automatic extraction uses AI pattern recognition. Manual extraction allows the use of any criteria the user wishes to define through options or script.

Step 2. Transform - a data map automatically connects each input field to each output field. The automatic mapping can be modified by visually connecting and disconnecting input and output fields or through scripting. Scripting can be used for extraction tasks, implementation of business rules, and other logic.

TextConverter leverages the VB Script engine to keep things simple. Powerful and precise conversion of text to useful data is accomplished through use of high-level objects such as the input dictionary, output dictionary, and proprietary utility objects for virtually any transformation task.

Step 3. Load - at run time the data flows from the source, through the transformation process and into the output data table, which can be any database system (SQL Server, ORACLE, MySQL, DB2, MS Access, etc.) as well as in a variety of flat formats including CSV, Excel, FoxPro, DBase, and more.

User Interface and Workflow Steps

1. Open the text file you would like to convert by clicking on the Open Data Source button. (or drag and drop the input file to the input pane.)
2. Change options like "First Page", "Exclude Lists", and "Trim Spaces" on the Options pane. The Input Dictionary and the Output Dictionary will be created automatically and linked field by field. If applicable...
1. Make changes to the Output Dictionary by editing the dictionary items, loading the Dictionary Object, or importing from other table(s).
2. Set up direct field mapping by selecting Input-Output field pairs and clicking Connect/Disconnect Input-Output Fields buttons.
3. Set up script conversion by selecting Create Script Conversion for any field and writing VB Script.
3. Preview results in the Output Table Sample. Use the Options pane to adjust settings and see the results immediately on the sample grid.
4. Set up the Output Table Name by clicking on the appropriate button on the Output pane.
5. Run the conversion process by clicking on the Start Process button.
6. View the final result in the output table viewer by clicking on the Preview Output Table button.

Works with Microsoft Windows