DEinspanjer , can I send you a mail or PM? Im almost satisfied but i have a couple of questions..

Absolutely. you just use the file: argument. e.g.: LogParser file:mySelect.txt -fNames XPath -i:XML -o:CSV or LogParser file:"C:\my queries\mySelect.txt" -fNames XPath -i:XML -o:CSV

Hi! I will have to test this.. Is it possible to put the whole SELECT statement in a separate file? Something like LogParser mySelect.txt -fNames XPath -i:XML -o:CSV

Here's one way you could do it.. SELECT TotalDocuments , PrintshopDocuments , OnDemandDocuments , ErrorDocuments USING SUM(CASE Name WHEN 'Printshop' THEN TotalDocuments2 ELSE 0 END) AS PrintshopDocuments , SUM(CASE Name WHEN 'OnDemand' THEN TotalDocuments2 ELSE 0 END) AS OnDemandDocuments , SUM(CASE...

Hello Im trying to parse a XML structure (below) and read the "TotalDocuments" tag depending on the Name attribute value. I would like to make a csv file with all the "TotalDocuments" element tag values. Ive tried something like: LogParser.exe "SELECT DISTINCT /Statistics/BillRun/ TotalDocuments , /Statistics...

You write a SQL query selecting the fields you want and filtering with a WHERE clause. The help file has plenty of information on the query syntax.

Hi, I am trying to parsy an xml file... I put in the logparser -h -i:XML c:\temp\test.xml the return is the shows the fields in the file.. how do i querry for those fields...

Got it. It was fixed, but in a version that hasn't been released yet. I'll send you a PM.

By the way, you would know this better than I, but URLEscape deals only with a few specific characters if it serves the traditional function of a URLEscape function. That is it only translates characters like &, space, <, >, and others that might be lost in translation of a URL transfered over...

Here is the xml with URLESCAPE on the Workstation field.