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*1 | abc*1 |
def | def |
ghi | ghi |
jkl | jkl |
1234 (remove) | mno |
mno | pqr |
pqr | AX*1 |
AX*1 | stu |
stu | vwx |
vwx | 1234 |
1234 | yz |
yz | AX*2 |
AX*2 | 1234 |
1234 | STM |
STM |
Solved! Go to Solution.
This is great! Thank you so much, Lelia!