Creating field names based on entry position


I have some interesting data to work with. I have a plain text file with Windows Events in it which some lines contain a field and value, while other lines only contain a value. The data is in json format and looks like this:

\r\nMay 07 09:14:08 2018\r\n665\r\nSecurity\r\n...

665 would be the Event ID
Security would be the Event Type

The logs don't have a field for those values, but they are always at the same spot in the log; the date is the 4th entry, 665 is the 5th, Security is the 6th, etc. Is there a good way to go about getting the data to be displayed like this in the end:

EventID: 665
EventType: Security

Many thanks

(system) #2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.