TMQL is an SQL-like query language which combines the simplicity and power of SQL with the unique characteristics of a text file and flexibility of regular expressions, into one powerful language designed to manipulate fixed size text files or delimited text files. For a query to be executed, Text Master first requires a connection to be created for a specific file and a query to be built. Read more…

Connection stores information about text files (such as file name, file type, fields structure, etc.) into separate files with “tmc” extensions. Once created, it can be used as part of the TMQL (SQL-like query language) queries to:

SELECT – view data;

UPDATE – change values of the individual fields;

INSERT – insert single line or selected number of rows from another file;

DELETE – specified number of lines from the file.

Logging records date and time of the file check along with the main characteristic of the file processed (file type, length, number of fields, etc.).

Profile contains general characteristics of the file (file type, delimiter (if any), minimum size, etc.) which can be partially derived from the file check and later be used as a base for comparison with the processed file in order to point to its origin.

Yes, two files can be concatenated using the Export feature combined with Append radio button selection.

Yes, you should have at least one log registered.  Once the file is checked,  use the “Add to log” toolbar button to save information into the selected log.

Yes, export to a new file all “good” lines. Using the “export” function isolate (export to another file) deficient  lines. Using NotePad (or equivalent software) modify wrong records. Once the file is “fixed” concatenate the two files.

If you have a large data file there is no other way to work with it except with TextMaster software. Read more…

Yes. Please go to TextMaster Quick Start page.