comma as decimal point in number

JosefVr — Thu, 08 May 2008 09:57:17 GMT

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!

Quantize on CSV input files - Not working

kewlapps — Thu, 20 Dec 2007 14:45:51 GMT

Hi ,
I have log files archieved in csv format. So with CSV input file I am trying to get a hit count and max Rt for every hour with the below query.

logparser "SELECT TO_LOCALTIME(QUANTIZE(TO_TIMESTAMP(date, time),3600)) as zHour, count(*) as hits, Max(time-taken) AS MaxRT FROM ex071105u.csv GROUP BY TO_LOCALTIME(QUANTIZE(TO_TIMESTAMP(date, time),3600)) ORDER BY TO_LOCALTIME(QUANTIZE(TO_TIMESTAMP(date, time),3600)) ASC" -i:csv

but all i get is

zHour Hits MaxRT
------ ------ ------
<NULL> 233837 192765

Please help.

Thanks in adv

Search results matching tag 'Quantize CSV Input'

comma as decimal point in number

Quantize on CSV input files - Not working