Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Input file formatting & filtering out needed fields

IJH34
8 - Asteroid

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 Code
1TU4R062011256AO010170705101M00
2TU4R062011259[NULL]
3TU4R062011254AO010170705101M01

 

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

2 REPLIES 2
AbhilashR
15 - Aurora
15 - Aurora

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

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

RobertOdera
13 - Pulsar

HI, @IJH34 

 

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

 

solution output

RNO2_0-1589992024606.png

 

Workflow

RNO2_1-1589992051222.png

Please see the attachment.

Cheers!

Labels