SQL – SELECT, UPDATE, INSERT,DELETE, TMDeDup … commands can be performed directly on the text file.
SELECT – provides data viewing functionality where every line (row) is presented as set of fields (columns). Filtering of the lines is done on the field level as well.
UPDATE – every field in every row can be updated with a fix value or value composed out other fields or part(s) of the other fields. Selection of the lines (filtering) to be updated, if required, is accomplished by defining criteria on the filed level.
INSERT – allows insert of the single line at the end of the file or insertion of the lines from another file by retrieving lines from the another file with SELECT command.
DELETE – removes lines based on on field(s) value and/or part(s) of the field values.
TMDeDup – removes duplicated rows based on field(s) value and/or part(s) of the field values.
TMHSplit – performs file split horizontally based on field(s) value and/or part(s) of the field values.
TMKeep – removes unwanted columns, group columns into new column, change length of the field(s) for fix file format, reformat field(s) values, add new fields, reorganize fields …
TMVJoin – converts group(s) of several lines in one file into line(s) in another file. Performs vertical join.
TMFile – performs Windows Explorer file related functionality (copy, move, rename …) as well as file split (number of line number or number of files are provided along with other parameters) and file join.
TextMaster provides wizards for query generation and editing capabilities for exiting query modifications.
SQL features are provided by TMQL™.
