Hi,
I'm attempting to extract data and time from a custom text file where date and time are split across two lines and contains two different combination of words in between them. A sample data I'm trying to ingest looks like...
PAGE 1 20-02-2019
ABC 08.03.45
data....
PAGE 2 20-02-2019
DEF 08.50.12
data....
The TIME_PREFIX is pretty straightforward but I'm stuck with how to define TIME_FORMAT to handle the inconsistent characters (i.e. ABC vs DEF) between the date and time fields.
TIME_PREFIX=^DATE\s{1}\d{1}\s{4}
TIME_FORMAT=%d-%m-%Y%n??? %H.%M.%S
@bobmacks for TIME_PREFIX, I don't see where the string DATE exists in your sample data. Is this the case?