Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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