I was having the same problem with the CRLF characters in the XML output, but the -compact N switch seemed to do the trick. Thanks.

[QUOTE User="LogParser User : rdcpro"]Quote: I have a report of Intrusing detections that outputs the following text to an XML file. <?xml-stylesheet type="text/xsl" href="Table.xsl"?> <ROW> <Messagetxt> HTTP_BA...[/QUOTE] I suppose that as old as this post is, no-one's interested any...

Hi, Does anybody know if there are plans to generate embedded xml schemas rather than DTD when using xml output? Thanks, An

Mailman, the timestamp format specifiers are case-sensitive. Y is different than y (for the same reason that M is different than m :-)). Everything not recognized as a specifier is output as-is.

If your post is the same as your code, you havent closed the string, it should be Select "To_String (Date, 'dd-MM-yyyy') Graham

Thanks Gabriele here is query Select "To_String (Date, 'dd-MM-yyyy) it works But I notice when I put YYYY I do not get the vaule of the year I got the String YYYY

Ahhhh.... my INTO was placed incorrectly: C:\Program Files\Log Parser 2.2>LogParser -i:IISW3C -o:XML "SELECT * INTO Logtes t.xml FROM C:\WINDOWS\system32\LogFiles\W3SVCxxxx\ex050427.log" Statistics: ----------- Elements processed: 19 Elements output: 19 Execution time: 0.02 seconds

Greetings, While this is my first foray into parsing log files, I was trying to see how easy (or how difficult) it would be to dump the contents of of a IISW3C into a XML file. Here was my first attempt: C:\Program Files\Log Parser 2.2>LogParser -i:IISW3C "SELECT * FROM C:\WINDOWS\sy stem32\LogFiles...

Use TO_STRING on the timestamp fields, passing in your own format.

Hi When I choose my output as XML I have problem with data it come in this format 2005-04-28 Ii wanted to be 28-04-2005 what should I do?