Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Trim function on text String

Deano478
12 - Quasar

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

2 REPLIES 2
DataNath
17 - Castor

Hey @Deano478, depending on the structure, here's a few ways I can think of doing this:

 

DataNath_1-1667554181415.png

 

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

Deano478
12 - Quasar

You quick response is much appreciated @DataNath after seeing your examples it was a great help and helped me past this rather annoying roadblock😂 many thanks 

Labels