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

Log entries show the following information:

Date – Date when entry was made

Time – Time when entry was made

FileName – Name of the file

FilePath – Path of the file

FileSize –  Length in bytes

FileType – Fixed or delimited

Delimiter – Shows that delimited files will contain delimiter and for fixed files it will be empty

NoLines – Shows the total number of lines per file

LineLength - Shows number of characters in row for fixed files, or number of fields in a row for delimited file.
If all rows do not have the same length, enter value will be shown as 'variable'

Comment – shows comments about the log entry.
If initiated from Toolbar, it will contain the following value so called 'Manual Log Entry'

top

ProfileName – Profile name

FileExtension – Extension of the file

FileNameStart – File name starts with value specified in this field. If field is empty the file name can start with any value

FileNameContains – Shows that the File name contains defined part (any number of characters) as part of its file name.
If field is empty File name is not following any know name pattern.

FileType – File type can be: fixed or delimited

Delimiter – For delimited files will contain delimiter, and empty space for fixed files

MinNoLines – File will have your minimum specified number of lines

MaxNoLines – File will not contain no more than previously specified number of lines

LineLength - Shows the number of characters in row for fixed files or number of fields in a row for delimited file.  If all rows do not have the same length the enter value will be 'variable'.

Connection Template -  connection template can be associated with the profile entry.

Connection Template contains description of the text file structure (type, delimiter, field

structure and order ...). Once file is checked and one or more entries were found in the

profile, connection for the file can be generated instantaneously.

Execute – information about action to be taken (query to be executed, DTS or SSIS

package to be processed etc.) can be stored in this field.

Comment – Comments about the log entry.
If initiated from the toolbar it will contain following value: 'Manual Profile Entry'.

All profiles are saved in .xml format but information can be exported also into .csv file and opened in Microsoft Excel or text editor for further processing.

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