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. No matter what type of data file you have, no matter the size or structure, TextMaster is for you. SQL Based Functions: SELECT, INSERT, DELETE, UPDATE Text Based Functions: TMHSplit, TMVJoin, TMKeep, TMFile, TMDeDup; Supporting String Functions; Supports all common .NET String functions, such as ToUpper, ToLower, Trim, Substring, Contains, StartsWith, EndsWith; Supports many other .NET functions and types, such as CONVERT, DATETIME.
Integrated Tools: FileCheck - Check file for inconsistencies, and view its structure and metadata. FileExport - Export a certain amount of data from one file to another, at random or sequentially. Detect and fix invalid records. FileTranscode - Change file encoding. FileSplit/Join - Separate and Merge flat files by binary size, number of lines, or desired file count. Powerful Document Editor Open common documents (.doc,.docx,.rtf,.txt,.csv etc) in free Word Processing component. Query Perhaps I have a 10GB Firewall log file, and want to see just the entries for a particular port and IP range? SELECT Port, IP FROM MyFirewall.log WHERE IP.StartsWith(192.168.0.) && Port == 443 Batch Query (Pro version only) Massage and transform as many flat files at once, build a chain of queries, use variables, see query statistics.What is new in this release:
- Version 3.0.1.9
- Fixed - Seek buttons on query would disappear in some circumstances.
- Fixed - Query wizard error for UPDATE command.
- Fixed - Query/Batch not showing correct extensions after Save, without Save As.
- Fixed - Improved initial loading times, and increased reliability of Syntax Coloring.
- Fixed - Taskbar Jumplists would present an error when trying to open. Added - Auto fit option for data grids.
- Added - Option to open .tmq/.tmb files from the Windows Explorer.
- Added - Command line arguments for automatic query/batch execution.
- Added - Would you like to save changes option, to query/batch windows.
- Added - Open Connection button to Ribbon. Plus various other minor improvements.
Requirements:
Microsoft .NET 4.0
Limitations:
15-day trial
Comments not found