How to use TextMaster Data Editor Pro

How to use TextMaster Data Editor Pro

Without describing a file (creating connection) the following can be done with a few clicks of the mouse: Edit - text files as set of monolithic lines (cut, copy, paste, replace, mark …) or as a set of lines where every line is divided into predefined number of fields. Every field can be addressed individually. Snippets, pre recorder field values, are available for quick and accurate entries. Split & Join - split file into several files based on number of lines each file should have or desired number of files. To split file: click on button, select a file, define number of files to split into or number of lines files should have and click on “Split” button. Join files - created by “Split File” feature into another file. To join file components: click the button, select any file component and click the “Join” button. Add, remove and rearrange file components. Split or join using different file encoding. Add line end to the fix position or after specified number of fields. Join files based on file name using “TMFile Join …” TMQL statement. 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. To check file, go to File >> Open and select file you want to check. Save results in Log(s) or Profile(s0.

File export - exports specified number of Input File Lines into the Output File or join multiple files. Segments of the file can be exported sequentially or randomly. To export data or join files: go to File >>Open, select file, click the “Text Export Setup” tab, modify export / join parameters (if needed)  and click the   button. By creating connection (describing the file) TextMaster standard SQL capabilities can be applied directly to the text file:  view data (SELECT statement), update any field (UPDATE statement), move lines from one file into another (INSERT statement) or delete lines based on field values (DELETE statement). In addition to the standard SQL commands, TextMaster provides additional commands designed to: de duplicate text file based on field(s) value (TMDeDup), split file horizontally based on field(s) value(s) (TMHSplit),  reformat file (remove column(s), add column(s), combine column(s),  change layout, rename columns,  etc. - TMKeep),  vertically split file into two or more files by combining TMFile and TMKeep etc. Convert your web logs, reports, e-mails into data files with TMVJoin. TMVjoin will convert group(s) of several lines in one file into line(s) in another file. Describe file only once, associate it with file extension on Windows level and every time you double click on the file in Widows Explorer file will be checked and displayed. To start, click the button and “TextMaster Query”  screen will open. Connection (file description) for any text file can be created from “TextMaster “ screen after file check (click the    button) or from “TextMaster Query” screen (select  Connection >> New). Create Query Batch and execute queries in sequential order. To start, from “TextMaster Query” open , add queries and save. To run batch, click , open batch (file with “.tmb” extension) and execute it. There is a lot of help available:
 * User’s Guide (182 pages “pdf” document) accessible from Windows (Start >> TextMaster >> Data Editor User’s Guide) or from the application (Help >> User’s Guide) provides details, instructions, examples …
 * Sample data with associated connections (file descriptions) can be loaded from Help >> Load Sample Data and used for training purposes;
 * Plenty of examples using sample data can be found in documentation which is copied to the local machine during installation (from windows Start menu select TextMaster >> Documentation) or on line Help >> On Line Help >> Documentation;
 * TextMaster Data Editor, Query and Query Batch have help button[[File:TextMaster Data Editor Pro7.png]] which opens screen with quick help related to respective topics.
 * Detailed quick start with TextMaster SQL (TMQL) can be found on line at http://www.textmaster.ca/Quickstart.htm;
 * Wizards are available for every SQL statement (SELECT, UPDATE,DELETE,INSERT,TMDeDup,TMHSplit …). To access them from TextMaster Query screen click the[[File:TextMaster Data Editor Pro8.png]] button.