Parsing a not regular log file

[Saraabdi955]

Hi,

I have a sample log file (like attached) and it has not a regular format in lines. It's breaking in middle of record suddenly.

How can I parse it?

[Felipe_Ribeir0]

Hi @Saraabdi955 

You can flag the 'Ignore XML Errors and Continue' and assign the value 'TagID' for the XML Child Element Name.

[ShankerV]

Hi @Saraabdi955 

What is the expected output please.

[EN6924]

By the way, What is the expected output?

[Saraabdi955]

Please watch the new file attached.

[Saraabdi955]

@ShankerV @EN6924 @Felipe_Ribeir0 

Please watch the new file attached.

I expect something like this:

TagID, Record
555, AAA
111, BB
666, CCC
..
...
...

[Felipe_Ribeir0]

Hi @Saraabdi955 

One way of doing this

[Saraabdi955]

Hi @Felipe_Ribeir0 

It's not correct. please pay attention the log file. The removed lines are part of the data and <Record> part.

[Felipe_Ribeir0 · Accepted solution]

Hi @Saraabdi955 

Please take a look at this new version:

[Saraabdi955]

Thanks @Felipe_Ribeir0 

It's correct.

Would you explain a bit about the middle tools, please?