How to take the last number in string column? please see details

[Ryanz3653]

Hi community, I have a column as follow, it is about size info, I would like to only get the last number in that sentence, if there is letters after last number, ignore it and get the last number. (please see the before and after)

Before: 

1/4"X1" RED
1/4in X 3/4in X 35 in
1/4in X 3/4in X 50 in
1/4in X 3/4in X 10 in

After:

1

35

50

10

what will be the formula to achieve this please? thanks for your help

[Qiu]

@Ryanz3653 
I always use this site for the RegEx.

https://regex101.com/

[flying008 · Accepted solution]

Hi, @Ryanz3653 

You can use formula like:

REGEX_Replace([Before], '^.*X\s?(\d+)\D*$', '$1')

[Gaurav_Dhama_]

Below formula should give you your results.

Tonumber(Right([Field1],FindString(ReverseString([Field1]),"X")))