TextMaster™ is a software tool for rapid analyzes and processing of fixed length or delimited text files. Features include: checking each record for line length, relevant file dates (created, last modified and last accessed) and provides you with the relevant statistics. SQL features provided by TMQL™ offer very powerful way for a text file viewing and processing where every line is viewed as collection of the fields rather than one unstructured set of characters. 

The results of the processing can be logged into an unlimited number of user definable logs and/or stored in profiles for future comparison with other files of unknown origin. An input file can be sliced and diced within minutes depending upon the user’s defined criteria.

Processing of files is breathtakingly fast. For example, a data file with 1 Million lines (99 bytes per line, fixed size) is processed within one minute on Intel Pentium 3.0 with 512 KB RAM. Majority of the Text Master functionality is divided into five groups:

File Check – scans every line of the specified file and determines its length, reports number of lines for each particular length and displays the line length statistics. At the end of the process, general file information is reported, as well:

	File length in bytes
	Date when it was created
	Date when it was last time modified
	Date when was the last time the file was accessed, and
	Shows if file is 'read only' or not

Once the file is selected, the file type (fixed or delimited) is automatically detected but this information can be overwritten, if needed. If file is delimited, delimiter will be determined as well.

top

The lines can be exported in sequential order starting from user specified position.

Export can be done in random order while the system by itself determines number of lines to be exported randomly, based on the parameters specified by the user.

More advanced exporting can be performed by SQL INSERT command.

top

File split supports different encodings (for source and component files), can add header to every component file (if required) or remove it from the first component file, component naming and destination is user definable…

top

top

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™.

top