Jorge Moreno 2006-02-10 - LogParser (from M$, http://www.microsoft.com/technet/scriptcenter/tools/logparser/default.mspx )
Very powerful parser, from what I reviewed and tried:
- Very Fast
- SQL like query definition
- output to a file, console, chart, Database
- multiple text files treated as a single set of data
- handles various file types (CSV, TSV, etc)
- much more...
I am currently working on a GUI for this Parser...made in Tcl of course :^)
Some Details:
There are commonly 3 files to define:
- The target file(s)
- The file that define the header (if header is not part of your target file)
- The file that define the SQL string (if you do not want to include the SQL in the command line)
add a reference to a sample CSV file here
more to come...