Re:Execute SQL against structured text like CSV or TSV
by burmask on Tuesday February 04, 2014 @09:55AM
(#7177733)
Microsoft LogParser is not only an established utility, it's extremely fast, too.
Re:Execute SQL against structured text like CSV or TSV
by DEinspanjer on Wednesday February 05, 2014 @07:29AM
(#7183335)
I remember LogParser from years back. I used to be very involved in that nascent community, and I developed a plugin for it that let you parse an input file using a regex with capture groups so you could use SQL queries on log files that did not have records with simple delimited columns.
http://technet.microsoft.com/en-us/scriptcenter/dd919274.asp...