Convert alphanumeric to numeric

Hi all,

I've found this solution but it didn't work for my case:

try Number.FromText([Text]) otherwise null

I've got a column that is build on alphanumeric characters. (SVF-11254, svf685, SVF742, ....) now I only need the number and nothing else to get the connection with another table right.

I can't use (I think) the delimiter because there are some numbers with 3, 4 or 5 numbers. 

With the solution of the 'try number.....' I also get null values for SVF9294 which need to be 9294

Thanks for the help!