Fixed - Seek buttons on query would disappear in some circumstances.Massage and transform as many flat files at once, build a chain of queries, use variables, see query statistics. SELECT Port, IP FROM MyFirewall.log WHERE IP.StartsWith(192.168.0.) & Port = 443 Perhaps I have a 10GB Firewall log file, and want to see just the entries for a particular port and IP range? Open common documents (.csv etc) in free Word Processing component. Detect and fix invalid records.įileSplit/Join - Separate and Merge flat files by binary size, number of lines, or desired file count. NET functions and types, such as CONVERT, DATETIME.įileCheck - Check file for inconsistencies, and view its structure and metadata.įileExport - Export a certain amount of data from one file to another, at random or sequentially. NET String functions, such as ToUpper, ToLower, Trim, Substring, Contains, StartsWith, EndsWith TMHSplit, TMVJoin, TMKeep, TMFile, TMDeDup No matter what type of data file you have, no matter the size or structure, TextMaster is for you. 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.īesides 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. This means that you can SELECT, UPDATE, INSERT, and DELETE, records from your data file without having to import it into a relational database. It allows you to very quickly and easily query your fixed/delimited files, as if they were an SQL database. TextMaster is an extremely powerful and unique flat file editor.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |