divide long sap order numbers with mess unknown dividers in between

[lilyyangadsk]

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

[Qiu · Accepted solution]

@lilyyangadsk 
Maybe this is what you want.

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

[atcodedog05 · Accepted solution]

Hi @lilyyangadsk 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

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

[jdunkerley79 · Accepted solution]

I would suggest two steps:

- Normalise the separators using RegEx

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

- Use split to columns to break it up

Have attached a sample

[lilyyangadsk · Accepted solution]

thank you it works well for me. 😀

[lilyyangadsk]

thank you, I think this is also good ways.

[atcodedog05]

Happy to help 🙂 @lilyyangadsk 

Cheers and Happy Analyzing 😀

[lilyyangadsk]

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