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


 

 

 

 

 

 

 

 

 

 

 

 

TextMaster file Split & Join v 3.0

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 



 

 

 

 

 



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...
More »

User Name:
 
Password:
 
Forgot your password?





Not registered?

Privacy Policy
 
 

     Generated Application Features:

bullet Size Check
bullet Text Export
bullet Logging
bullet Profiling
bullet SQL: Select
bullet Update
bullet Insert
bullet Delete
bullet TMDeDup
bullet TMKeep
bullet TMHSplit (Horizontal Split)
bullet TMVJoin (Vertical Join)
bullet Query Batch
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

Quick Start

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 

top 

Contact us today for more information!

Go to our Download section to get our White Paper or simply follow the instructions to download your copy of TextMaster right away!

 


 

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