I've got data that looks like this:
Date is the fourth column, and time is the fifth. Got any ideas about how to get TIME_PREFIX, TIME_FORMAT and MAX_TIME_LOOKAHEAD to get this right?
My latest try is:
TIME_PREFIX = ^[^|]|[^|]|[^|]*|
TIME_FORMAT = %Y%m%d|%H%M%S
MAX_TIMESTAMP_LOOKAHEAD = 20
I think the only issue is your TIME_PREFIX. The regex you have only matches a single non-pipe character between each pipe. For what you have, you want:
TIME_PREFIX = ^[^\|]+\|[^\|]+\|[^\|]+\|
Then the rest should work as intended.
(Replace + with * if any of the preceeding fields might be empty. |||20131013|...)
EDIT: Also need to escape the pipes, as sowings mentioned.