Worldwide delivery
Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor.
TextMaster is an extremely powerful and unique flat file editor. It allows you to very quickly and easily query your fixed/delimited files, as if they were an SQL database. This means that you can SELECT, UPDATE, INSERT, and DELETE, records from your data file without having to import it into a relational database.
If you’re not an SQL master, don’t worry, we have many easy examples, and a wizard, to walk you through the query building process.
Besides the usual SQL operations, you can perform other functions that are text file specific, such as splits or joins, removal of duplicate records, editing of columns, transforming multi-line text into a single line etc.
With TextMaster you can automate data modification processes via sophisticated multi-step query batches, or define templates so that new data files can be processed with only a couple of clicks!
Are your large text files corrupt through mistaken input or other forms of user or software error? Do you want to quickly identify these errors in order to repair them or eliminate the record or records in question? Have you ever wanted to run SQL query directly on your fixed length or delimited text file but haven’t been able to find software to do that?
Text Master™ is your route to quickly and easily resolving these problems! Best of all, TextMaster™ is exceptionally cost effective, easy to learn and easy to implement.
TextMaster™ is a software tool for rapid analyzing and processing of fixed length or delimited text files and/or for slicing and dicing data within the file. Features include each and every record line length check, file statistics, SQL commands for data viewing, updating, deletion, insertion…
Size Check
STANDARD | PRO | |
---|---|---|
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
STANDARD | PRO | |
---|---|---|
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
STANDARD | PRO | |
---|---|---|
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 | ![]() |
![]() |
SQL Select
TEXTMASTER APPLICATION FEATURES: | STANDARD | PRO |
---|---|---|
|
||
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) | ![]() |
![]() |
TextMaster Application 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 | ![]() |
![]() |
Remove duplicated lines from the file – TMDeDup |
||
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 | ![]() |
![]() |
Change file structure – TMKeep |
||
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 | ![]() |
![]() |
Split file into several files based on field(s) values – Horizontal Split (TMHSplit) |
||
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 | ![]() |
![]() |
Join several lines into single line – Vertical Join (TMVJoin) |
||
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 | ![]() |
![]() |
Execute queries in sequence – Query Batch |
||
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 | PRO |
Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor.
Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.
Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim.
Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor.
Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor.
Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor.
enean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus.
enean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus.
One panel or as many as needed