Input file formatting & filtering out needed fields

Question

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 IDTU IdentifierAO01 Code1TU4R062011256AO010170705101M002TU4R062011259[NULL]3TU4R062011254AO010170705101M01

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

2020-05-20_10-30-01.pdf

TEST DATA.txt

AbhilashR · Accepted Answer

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 Answer

HI, @IJH34

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

solution output

Workflow

Please see the attachment.

Cheers!