I would expect the iTsFormat option to work for you, but maybe you could try setting DTlines to 0 to turn off automatic type parsing.

This is probably easy but given an input csv like REC_DATE,ACC,ORD_LOC,ORD_ 01302007,07-030-2368,ART,4028232 I am using the COM interface to parse into an Access Table. I want REC_DATE to be a date filed in the table. I tried setting oInput = CreateObject("MSUtil.LogQuery.CSVInputFormat") oInput.headerRow...

Hi, I try to get the first date of some SMTP Logfiles. I read something about to_timestamp in the log parser help file, but I don't get it This is an example line: 217.98.20.10, OutboundConnectionResponse, 29.08.2006, 23:00:49, SMTPSVC2, WIMX025, -, 1782, 0, 18, 0, 0, -, -, 250-cymon.tpnet.pl, Many thanks...

One of the few ways to speed up logparser is to change the order of Where clauses, though even that does precious little. In this case, I am not sure the order could be improved. One other thing that has helped (though harder to do) is find a RAMDisk that can fit your file. Having it all in memory makes...

With two million records, I doubt you would find any non-database solution that would be "almost instant". Any sort of disk access for line parsing a file of that size is likely to take a measurable amount of time. I believe you must look at putting this data into some sort of database that supports...

Hello I was wondering what I can do to speed up log parsing if at all possible. I am using log parser to query a list of post codes there are 2million records and I would like the result to be almost instant, I'm not sure if there is possible because there are so many records. The code below taks about...

What was the fix for this?

[QUOTE User="LogParser User : trwagner1"]Quote: [QUOTE]This is what I've tried: WHERE TIMESTAMP([DATE], 'MM/dd/yyy') > TO_DATE(SUB(TO_LOCALTIME(SYSTEM_TIMESTAMP()), TIMESTAMP('7', 'd'))) But, I keep getting several errors. Is there a different wa...[/QUOTE] OH! Ok, [kick self in the butt] Sorry about...

[QUOTE User="LogParser User : DEinspanjer"]Quote: I have a date column we'll just call [date]. It's format is mm/dd/yyyy Unfortunately, I can't change the logging date, so I have to work with what I have. I have one query which needs to ...[/QUOTE] [QUOTE]This is what I've tried: WHERE TIMESTAMP([DATE...

[QUOTE User="LogParser User : trwagner1"]Quote: Converting to an int does work fine. Your second try was almost right, you just needed to call TO_TIMESTAMP([Date]...) instead of TIMESTAMP([Date]). The TIMESTAMP function is only useful for turning...[/QUOTE] I don't think I'm following what you are saying...