Regex formula

[SH_94]

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

[IraWatt · Accepted solution]

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%20...

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[ShankerV]

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

[PanPP]

Hi @SH_94 

Another way of doing this.

If it helps, please like the post and mark it as a solution.