Hi,
Another option you could do, assuming your data is more of a 'one off' that continually updating, is just fix the format in Excel or Google Sheets.
So something like:
=TEXT(cell_ref, "000000")
Which gives you:
I find sometimes that it's easier to fix-up the data first, before Indexing it into Splunk.
It's not always possible, depending on how your data is flowing in, but if you can, then tweak it first.
The 3rd column was just to check how the Padded string would be interpreted (or as an easier to read column in the data). The formula for this is:
=TIME(LEFT(cell_ref,2),MID(cell_ref,3,2),RIGHT(cell_ref,2))
... View more