SELECT, UPDATE, INSERT,DELETE, TMDeDup ... commands can be performed directly on the text
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.
- 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.
removes lines based on on
field(s) value and/or part(s) of the field values.
duplicated rows based on field(s) value and/or part(s) of the field values.
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 …
- converts group(s) of several lines in one file into line(s) in another file.
Performs vertical join.
- 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™.