I have the following sample data in a csv file.I am trying to import it but its unable to break the line and detect the timestamp.
"Jun220.127.116.11, LVVL@abc.LOCAL, InOctets, 557766140, OutOctets, 3462815293, Total MB used, 502.572679125"
"Jun18.104.22.168, ALU@abc.LOCAL, InOctets, 4238119433, OutOctets, 3683403330, Total MB used, 990.190345375"
"Jun22.214.171.124, RXGH@abc.LOCAL, InOctets, 233853544, OutOctets, 485536206, Total MB used, 89.92371875"
Assuming your timestamp is the first field, try setting your TIME_FORMAT to %b%d.%y.%H.%M
Having said that, what do dates with single digit days look like e.g. Jul01.22 or Jul 1.22 or Jul1.22?
Jun126.96.36.199 ....here Jun30th is the date with year as present and 22.21.55 is the time ...with single date it will be Jun01
I tried using %b%d.%H.%M.%S in TIME_FORMAT but it did not recognize the time.I am attaching the screenshot of how it looks when uploaded through UI.
[ csv ]
description=Comma-separated value format. Set header and other settings in "Delimited Settings"
Try including TIME_PREFIX = ^
I tried that no luck