Have several lines of data where I need to parse out specific pieces of data
Example:
Customer PAGE1234 / P AGE LLC Type: Paypal Phone: 123 123-1234
I guess I need to be able to configure where the parse starts and stops considering I have several lines of similar data and some names are longer than other. Is there a way to parse this information out into new columns given the character numbers will vary per column?
Thanks
Solved! Go to Solution.
Is that the RegEx tool? Or something else?
it’s my way of testing the pattern that I suggested earlier to see if it pulls out what is necessary - the highlighted portions show that it would parse correctly. Regex101.com
Attached a snip of the data
I will not help further until Alteryx is attached or actual errors are shown - I have given enough direction and shown proof of it working with the exact example given
User | Count |
---|---|
60 | |
24 | |
24 | |
21 | |
21 |