SQL on Text? Imagine the possibilities....
With TextMaster you have all the tools you need to modify large text files with ease.Our powerful and unique editor allows you to easily query your fixed/delimitted files as they were an SQL Database
Please compare editions and choose yours with confidence!
TM Data Editor features |
Standard |
Pro |
Size Check |
||
| Check line length | ||
| Process fixed and delimited text files | ||
| Display First, Mid and Last line length | ||
| Display number of lines per record | ||
| Display file length and relevant dates | ||
| Estimate completion time | ||
Text Export |
||
| Export sequentially | ||
| Export Random number of lines | ||
| Export Random percentage of lines | ||
| Only lines of specified length | ||
| Only lines different than specified length | ||
| Append or overwrite a specified file | ||
Logging |
||
| File processed with all info associated to the file | ||
| Save crucial info about file's processed: date, time, size... | ||
| Provide manual entries / adjustments | ||
| Unlimited number of logs | ||
| Unlimited number of log entries | ||
Profiling |
||
| Save crucial info about file for future comparison | ||
| Provide manual entries / adjustments | ||
| Unlimited number of profiles | ||
| Unlimited number of profile entries, per profile | ||
| Check file processed against all entries in a selected profile | ||
SQL Select |
||
| Select all or only specified fields |
||
| Skip a selected number of lines | ||
| Filter lines based on field values | ||
| Select fields composed out of other fields | ||
| Rich set of text manipulation functions such as: Trim, ToUpper, ToLower, etc. | ||
| Supports aggregates (count, min, max and sum) | ||
SQL UPDATE |
||
| Update any or all fields | ||
| Skip a selected number of lines | ||
| Filter lines based on field values | ||
| Set the field value to the combination of any other fields value/s | ||
| Rich set of text manipulation functions such as: Trim, ToUpper, ToLower, etc. | ||
SQL INSERT |
||
| Insert a line into a table by specifying field values (single line entry) | ||
| Utilizing a 'select statement' determine structure, number of lines and criteria to copy from one file into another one | ||
SQL DELETE |
||
| Delete all or a specified number of lines | ||
| Preserve and/or delete a selected number of lines | ||
| Delete lines based on specific field values | ||
TM DEDUP - Removes duplicated lines from the file |
||
| Specify one or more fields as criteria | ||
| Specify part(s) of the field(s) as criteria | ||
| Limit de duplication to the portion of the file | ||
TM KEEP - Modifies/change the file structure |
||
| Add field | ||
| Remove fields | ||
| Concatenate fields | ||
| Create new field from field(s) or part of the field(s) | ||
| Change field order | ||
| Filter rows based on field(s) or part of the field(s) value | ||
TM
HSplit - Horizontal split
|
||
| Single field can be used as splitting criteria | ||
| Multiple fields can be used as splitting criteria | ||
| Combination of field(s) and field(s) segments can be used as splitting criteria | ||
TM
VJoin - Vertical file join
|
||
| Convert entire file into single line | ||
| Convert groups of lines into several line (one line per group) | ||
| Group indicator (marker) can be at the beginning or at the end of the group | ||
| Group indicator (marker) can be at the beginning, end or part of the line | ||
Query Batch - Execute queries in sequence |
||
| Edit batch (open, save, history list...) | ||
| Find / replace parameters | ||
| Execution details | ||
| Error report | ||
| Execution statistics summary | ||
| Execute batch | ||
| Conditional custom error(s) supported | ||
| Conditional summary report supported | ||
| Constants (string, int, long, decimal, char and DateTime) can be declared and used | ||
| Variables (string, int, long, decimal, char and DateTime) can be declared and used | ||
Standard $99.00
|
Pro $149.00
|
|