TextMaster Data Editor Standard Edition 3.0.1.9
extMaster 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.nIf 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!nBesides 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.nNo matter what type of data file you have, no matter the size or structure, TextMaster is for you!nSQL Based Functions:nSELECT, INSERT, DELETE, UPDATEnText Based Functions:nTMHSplit, TMVJoin, TMKeep, TMFile, TMDeDupnSupporting String FunctionsnSupports all common .NET String functions, such as ToUpper, ToLower, Trim, Substring, Contains, StartsWith, EndsWith, etcnSupports many other .NET functions and types, such as CONVERT, DATETIME etcnIntegrated Tools:nFileCheck - Check file for inconsistencies, and view its structure and metadata.nFileExport - Export a certain amount of data from one file to another, at random or sequentially. Detect and fix invalid records.nFileTranscode - Change file encoding.nFileSplit/Join - Separate and Merge flat files by binary size, number of lines, or desired file count.nPowerful Document EditornOpen common documents (.doc,.docx,.rtf,.txt,.csv etc) in free Word Processing component.nQuerynPerhaps I have a 10GB Firewall log file, and want to see just the entries for a particular port and IP range?nSELECT Port, IP FROM MyFirewall.log WHERE IP.StartsWith(192.168.0.) && Port == 443nBatch Query (Pro version only)nMassage and transform as many flat files at once, build a chain of queries, use variables, see query statistics etc