HI community,
Would like to ask how can we split the following number into three category
INput
1. 273D2347.75
2. 1060C8732.85
Category 1 - 273
Category 2- D
Category 3 - 2347.75
Category 1 - 1060
Category 2- C
Category 3 -8732.85
Thank you
Hey @SH_94,
Given your examples here is one way:
(\d+)(\D+)(.*)
The first group captures 1 or more numbers, the second group captures one or more Non numbers, and the third group captures what is left.
If you want to learn more about Regex the community has some really quick interactive videos on getting to grips with it here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Parsing%20Data
Any questions or issues please askIra WattTechnical ConsultantWatt@Bulien.com
Hi @SH_94
One way of doing this.
Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.
If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!
Many thanks
Shanker V
Another way of doing this.
If it helps, please like the post and mark it as a solution.
