1. Strip all instances of '-\n'
2. Replace '<cr>^U^[' with '<cr>'
3. Strip all remaining '^U^['
Now each entry is on its own line, each paramater/value pair is separated by ^[.
4. Cycle through each entry by separating the log by '\n'.
5. Cycle through each pair in the entry by separating with '^['.
Each paramater is the string before '=' and the value is the string after '='.
6. Make an SQL query or append a line to a CSV file with the values of each parm.
Parms:
MGR_NUM int
ENTRY_DATE date(%Y%m%d)
ENTRY_DATE_DISP null
ENTRY_TIME 00000000 + date(%k%M%S) + 00 or date(%Y%m%d%k%M%S) + 00 (those last two zeros are the two decimal places of a second, this field only shows time, the date descriptors are all zero'd)
ENTRY_UNIQUE_NUM int
ENTRY_TYPE int
ENTRY_KEY null
UPDATE_DATE date(%Y%m%d%k%M%S) + 00 (the date values are here in this one)
U_VERSION '!'
ENTRY_LOG string
ENTRY_LOG can be further tokenized by splitting it with '<cr>'. Each of these tokens follow the format: date(%k:%M:%S).(first two decimal places of the second)'W'(not sure what this is, maybe W for Wednesday, doubt it...)':'MESSAGESTRING
MESSAGESTRING sometimes contain <cr> and <ak>, you probably just want to keep those as is.
The date() I used it the POSIX one that comes with UNIX installs, and won't work verbatim with PHP and possibly PERL, Windows, etc. If you figure that you can't make a parser for this yourself, then I might have enough time over the weekend to whip something up if you don't mind showing my paypal some love.
