Hello fellow Alteryx enthusiasts,
Just a quick one for you all I have a large data set containing many text strings as seen below and I cant for the life of me figure out how Trim the text to just keep the number part.
Any assistance is greatly appreciated it might be quite simple but I just cant figure it out
INPUT
5. Expect to be fully operational; no requirement for additional work
DESIRED OUTPUT
5
Solved! Go to Solution.
Hey @Deano478, depending on the structure, here's a few ways I can think of doing this:
Option 1 - Relies on a dot always following the number
Option 2 - Just takes the first char of the string (no good if you have more than single digit numbers)
Option 3 - Just removes all non-numbers from the string
Option 4 - Same as option 3 but is specific to the start of the string