Trim number

[SDP]

Hi - Please see sample dataset below, I wanted get only numeric numbers after #. Datatype is a string. I have tried LeftTrim and RightTrim but it did not work. Please let me know how I can do in Alteryx Designer. Thank in advanced. 

3;#0000009745

8;#0000080767

8;#0000080725

24;#0000112190

29;#0000208669

33;#0000272091

33;#0000272056

44;#0000209289

44;#0000289232

47;#0000306474

48;#0000300983

79;#0000321488

1639;#0000303100

[gawa · Accepted solution]

hi @SDP 

Regex tool or Text to Column tool will help. I recommend to use Regex tool but if you are not familiar with it, you can go with Text to Column.

Please see the sample WF as attached.

[SDP]

Hi Gawa -- Thanks. It worked, however, I have following dataset where I am trying to use similar solution you have mentioned but it is not working for following scenario. Thanks

Not Started
Not Started
Not Started
3;#In progress
Not Started
Not Started
Not Started
Not Started
Not Started
Not Started
Not Started

[aatalai]

@SDP If you want to use the formula tool try this formula

getright([field],"#")