Hi, I am running logparser, in a vbs script using the logparser object. The vbs file that runs logparser is below. It places all the files of a folder (recursing) and places them in a text file. ============================================= Dim objLogParser, objInputFormat, objOutputFormat, strQuery...

Hello: I have an issue in querying TSV format data files with some fields having nulls (no-data). The issue here is that logparser is considering the subsequent field value for the current field and messing up the data format. Please verify the query, sampledata and output pasted below to see the problem...

Hi There, I am not familiar with HL7 logs, but if they are just a text file with | delimited data, then you can use logparser to pump it straight into your Access database. You can also let logparser determine your data types from the data, so that you will not need to do a data import into Access. Look...

Hi Any plugin available that will allow to parse zipped files? Jürg

The goal here is to craft a query whereby an IP address is suppled, and the result returned is a list of all urls accessed. The syslog file is a text file, tab-delimited, in the following format: 2008-05-21 08:49:58 Local6.Notice 10.13.30.2 %PIX-5-304001: 10.17.90.10 Accessed URL 206.190.50.59:/serv...

Does logparser support localized numbers (decimal point is comma) in csv file? If so, is there anything special needs to be done to get this going? Thanks!

Graham is correct, out of the box Log Parser won't do what you want. That said, the format looks pretty simple. If you can write a little bit of VBScript (or JScript), you could make a custom input parser (which would allow you to take advantage of the rest of Log Parser's features.

Unfortunately, Logparser cannot really deal with multine type records; your best bet is to use a short vbscript to reformat it Graham

I am beginner - hope anyone can advise me. Have following textfile !Subject,!From,!Date,!Lines,!Body Subject:aaa From:bbb Date:ccc Lines:ddd Body:eee ......body lines..... !Subject,!From,!Date,!Lines,!Body Subject:fff From:ggg Date:hhh Lines:iii Body:jjj ......body lines..... and want new textfile (ready...

Hello All, I have a question about how to calculate the time elapsed between the log file timestamp and the current system time. I have a log file in the format shown below and the StartTime is the time in which a software license was checked out. BXW01 McWhorter-B01 McWhorter-B01 (v1.000) (CDCLM1/27001...