Convert alphanumeric to numeric

[Anonymous]

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!

[HashamNiaz · Accepted solution]

Hi @Anonymous !

Please try creating a new Column from example in Power Query Editor;

In the new column example type only Integer values for the column, you need to provide 3/4 example value and it will generate M Code to create the new column containing only integer values.

Column from Examples 

Regards,

Hasham

[Anonymous]

That works, thanks!