This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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...
I've also attached a file with sample data to help come up with a solution. Thank you.