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

divide long sap order numbers with mess unknown dividers in between

lilyyangadsk
9 - Comet

I try to parse SAP order number original column as attachment to split 1,2,3,4..., but there are different SAP order numbers in between input by sales rep with ' or ; or and or space etc, can teach how to parse order number in such mess case? thank you

7 REPLIES 7
Qiu
20 - Arcturus
20 - Arcturus

@lilyyangadsk 
Maybe this is what you want.

Appreciate if you could mark it as accept if you find it useful.

1109-lilyyangadsk.PNG

atcodedog05
22 - Nova
22 - Nova

Hi @lilyyangadsk 

 

Here is a workflow for the task.

Output:

atcodedog05_0-1604921150009.png

 

Workflow:

atcodedog05_1-1604921165971.png

 

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

jdunkerley79
ACE Emeritus
ACE Emeritus

I would suggest two steps:

jdunkerley79_0-1604921432858.png

 

- Normalise the separators using RegEx

REGEX_Replace(
REGEX_Replace([Field1], " and |\)\(|[ ,;]+", "|"),
"^\(|\)$", "")

- Use split to columns to break it up

 

Have attached a sample

lilyyangadsk
9 - Comet

thank you it works well for me. 😀

lilyyangadsk
9 - Comet

thank you, I think this is also good ways.

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @lilyyangadsk 

 

Cheers and Happy Analyzing 😀

lilyyangadsk
9 - Comet

thank you, it works well and this is good ways, just a bit complex to me. 😅

Labels