Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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, S...
Need Help
  • HashamNiaz's avatar
    HashamNiaz
    5 years ago

    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

HashamNiaz's avatar
HashamNiaz
Solution Sage
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

That works, thanks!