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
(Splits one file into several ones based on field(s) values)

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
(A single function that allows you to join several file lines into a single one)

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  

DOWNLOAD FREE TRIAL

Standard $99.00

Pro $149.00