How?
If you have 100 lines in a data file you can count them manually. For a 10,000-line Spread Sheet – or similar – text editor will do the job. But for 1 Million lines, there is no other solution than TextMaster. Available on the market today and will do it with just one click!
How?
All lines in a fixed size file are expected to have the same number of characters per line. TextMaster will check each and every line and report all field lengths found (up to 100) along with the number of lines for every length group.
For delimited files TextMaster will count the number of fields for each line and report (up to 100) different field count values with a line count for every field count group, respectively.
How?
Lines with unexpected line length, for fix files, or unexpected number of fields, for delimited files, can be exported, manually fixed or fixed using TextMaster SQL features and integrated with “good” data quickly and easily.
How?:
Information about file (type, length, extension, minimum number of records…) can be saved as a profile entry. If you are not sure what to do with just received file then compare it against saved profiles and your answer might be right there.
How?
Log date and time stamped main file characteristics (file name, extension, number of lines ) with your comments into unlimited number of logs with two clicks.
How?
Selection criteria for all TMQL commands, utilizing regular expressions, can compare values of the fields against expected structures. Search the Web and find out more about power of the regular expressions.
How?
Create query using query builder or just by typing it into command line and you will be able to view all or specified fields, all lines (rows) or only lines with a content you are interested in by applying various filtering criteria. You can save results into another file with just one click.
How?
You can change any field (column) value in the file with constant value, value from another field, combination of the field values or parts of the field values. Only lines (rows) which meet criteria based on the field values will be updated. (see TMQL UPDATE statement in User’s Guide for more details)
How?
Create DELETE query using query builder, by modifying already saved query or just by typing it into command line and you will be able to delete all lines (rows) from the file or only lines with a content you are not interested in by applying various filtering criteria. (see TMQL DELETE statement in User’s Guide for more details)
How?
Create TMHSplit query using query builder, by modifying already saved query or just by typing it into command line and you will be able to split file into several files based on single field value, multiple fields value or field(s) segment(s). By defining filtering criteria (optional) partial splitting can be achieved. (see TMQL TMHSplit statement in User’s Guide for more details)
How?
Create TMKeep query using query builder, by modifying already saved query or just by typing it into command line and you will be able to rearrange fields, add new fields, remove fields, concatenate several fields into single field, rename fields …. . (see TMQL TMKeep statement in User’s Guide for more details)