Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jorismo
Helper II
Helper II

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!

1 ACCEPTED SOLUTION
HashamNiaz
Solution Sage
Solution Sage

Hi @jorismo !

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

View solution in original post

2 REPLIES 2
HashamNiaz
Solution Sage
Solution Sage

Hi @jorismo !

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

That works, thanks!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.