Home
Products
Downloads
F.A.Q.
Support
Contact Us
Order
 


 

 

 

 

 

 

 

 

 

 



 

 

 

 

 

 

Why TextMaster Data Editor?

 

When your file is also a large data file - TextMaster Data Editor is a must!

Why? How?

 
 

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


 

 

 
  Copyright 2012, Exnp Inc. TextMaster® is a registered trademark. All rights reserved. Privacy Statement    Become EXNP Affiliate