About
Data Extractor allows you to extract sparse data contained within files and assemble it into an internal structured table. The collected data can be exported at any time in various formats (CSV, TSV, HTML, Custom). The data extractor can analyze thousands and thousands of files in a few seconds and collect all the raw data inside.
It uses simple instructions on how to recognize the data, how to extract it, and where to put that data inside a structured table ready for export.
It can parse all the text files you specify and analyze them, understanding from the text tags what needs to be extracted and where.
Data Extractor transforms chaotic data into orderly data.
And all this in just one click.
Why is this necessary?
- If you have a lot of text files with data inside and you want to transfer them to a structured database with fields and records.
- If you need to extract data recognized within various text documents by different types of start and end tags or location.
POWERFUL
- Data Extractor can extract data that would take weeks, months or even years to collect manually.
- He will do it for you in a few seconds, he can scan thousands of texts, analyze, copy the necessary data, place them in a table you create with the necessary fields.
- Uses various options to extract data from thousands and thousands of files and store them in an organized manner.
- Provides all the tools to intelligently perform these specific tasks in a beautiful and elegant, Mac-only, native application.
- Data can be exported to various formats, ready for use
Ease of use
- In the "Sources" section you specify which text file needs to be parsed, or folders for navigation and parsing.
- In 'Accept file rules' you specify how to accept the contents of the file for parsing.
- You specify in 'Create Record Rules' when to insert a new record into the data destination
- You specify in 'Extract Rules' what to extract and where to put it
- In 'DataBase' you specify the table to collect data from.
- In 'Run' you can run and view a summary of the results.
Features
- Document based, you can use a different set of data sources for each document
- Documents can also be configured to quickly batch process large amounts of data with defined extraction and assignment rules.
- Can convert customer orders or any set of data received via email into database records (Data Extractor can directly analyze emails pointing to your mailbox on your hard drive).
- Collect orders received as server output if they are not inserted directly into the database.
- Extract data from files one by one, also by dragging and dropping them using Drag & Drop
- Works great with emails received by Mail.app
- Can process folders, extracting data from all files inside, nested at any level
- Converting data presented in one format to another if the first format uses a recognizable template with labels to identify data fields
- Customizable data column positions
- Extracting data from files where the data is written in one file and the records are separated only by a distinguishing line
- Extracting data from files where records are separated by a new line and fields on the same line are identified only by labels
- Extract data from a text document with non-unique, ambiguous tags, using special tags useful for telling Data Extractor where to actually start collecting data
- Parse files only if they meet certain characteristics
- Extract data only if it meets certain characteristics
- Retrieve data also if it is specified by more than one label (it can put different retrievals in the same destination field)
- Can use 'Case Sensitive' option for data labels
- Can run in the background
- Always responsive, including when extracting from a folder with thousands of nested files at any nesting level
- The user can stop the process at any time
- Internal database table, fully customizable, to collect extracted data.
- Export data to various formats (CSV, TSV, HTML, Custom) with various options
- Includes a PDF user manual with 4 practical lessons on how to use the app