Input file formatting & filtering out needed fields

[IJH34]

I have a file that doesn't seem to have a delimiter. I'm struggling to break the file apart and/or grab only the fields I absolutely need. Ideally, I only need the tags outlined in red, starting with TU4R and AO01. The problem is every instance starts with TU4R and ends with ENDS01, however not every instance contains a AO01 tag. (See the attached screenshot.)

This is how I'd like my final output to be...doesn't need to be exact but close...

Record ID	TU Identifier	AO01 Code
1	TU4R062011256	AO010170705101M00
2	TU4R062011259	[NULL]
3	TU4R062011254	AO010170705101M01

I've also attached a file with sample data to help come up with a solution. Thank you.

[AbhilashR · Accepted solution]

Hi @IJH34, attached is one way you could achieve the output you are looking for. 

Let us know if this doesn't work on your larger dataset.

[RobertOdera · Accepted solution]

HI, @IJH34 

Please mark as an acceptable solution + Like, if this works for you.

solution output

Workflow

Please see the attachment.

Cheers!