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

Parsing Repeating Field

eggers78
6 - Meteoroid

Hello!

Looking for a way to parse out the first occurring “1234” field in a file whose only unique/consistent characteristics are that it will always be the first occurrence that will need removed, and that it will always be located above the “AX*1” field? I stress first occurrence as you can see that the “1234” field will repeat within the same customer record. This process would need to repeat multiple times in the same file. “abc*1” and “STM” would always mark the beginning and end of a customer record within the file. The 1234 field that needs to be removed can show up in different rows as the size of each customer record will range, but the unique characteristics of it being the first occurrence as well as being located above the “AX*1” field will remain constant. Any help on this would be greatly appreciated. Thank you!

 

abc*1abc*1
defdef
ghighi
jkljkl
1234 (remove)mno
mnopqr
pqrAX*1
AX*1stu
stuvwx
vwx1234
1234yz
yzAX*2
AX*21234
1234STM
STM 
2 REPLIES 2
ncrlelia
11 - Bolide

Hi @eggers78 

 

Please see attached my suggested solution.

Hope it helps.

 

Cheers,

Lelia

eggers78
6 - Meteoroid

This is great! Thank you so much, Lelia!

Labels