Can someone please help me get the desired output?
Input | Output |
F2or0th-e0ta8xa8b0le3ye3a1r | 20-0880331 |
Solved! Go to Solution.
Hey @rrahu07 , not regex but you can use the Data Cleansing tool instead to remove all letters from the cell. It will give you the desired output.
Hey @rrahu07,
Here is one way to do this:
The regex:
[\d-]
Matches with any dash or number creating a new row from it. I then use the summarize tool to bring it all back together.
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!
Hope that Helps
Ira Watt
Technical Consultant
Watt@Bulien.com
That was a good solution. I was trying to make it complicated for no reason. THANKS @michelle_mathews