|
It will find out if your file has the exact number of lines
that you
expect it to have.
How?:
If you have 100 lines in data
file you can count them manually. For 10,000 Spread Sheet or similar text editor
will do the job, but for 1 Million lines there is no other solution but
TextMaster available on the market today which will do it with one click!
 top
TextMaster Data Editor will easily find out for you if your text file has expected file structure.
How?:
All lines in a fixed size file
are expected to have the same number of characters per every line.
TextMaster will check each and every line and report all field lengths found (up
to 100) along with number of lines for every length group.
For delimited files TextMaster will count number of fields for each and every
line and report (up to 100) different field count values with line count for
every field count group, respectively.
top
TextMaster Data Editor will isolate “bad” lines, fix them and bring them back
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.
top
With only one click TextMaster Data Editor will determine your file structure and
know what to do with it.
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.
top
Log main file characteristics of the files received or sent for
reporting purposes
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.
top
Find out if any field in the line is well formatted e-mail, well
structured phone or fax number, valid postal / zip code
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.
top
TextMaster Data Editor will view all or selected number of fields from the file based on your
criteria and save results to another file by pointing to the file you want
it to
be saved to.
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.
top
TextMaster Data Editor will update any field value in lines of your choosing in the data file
without importing it into database, spread sheet or anywhere else.
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)
top
TextMasterData Editor will delete unwanted lines
from the data file based on your criteria.
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)
top
Split file into several files based on file content.
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)
top
Rearrange fields, add new field(s) and / or drop fields from
the fixed or delimited file with single statement.
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)
top
|
