Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
70
Views
Topic starter
Hello!
I'm trying to extract numbers from a column. Some of the numbers include decimal numbers. When I do the extraction, the decimal point is removed. Is there a way to extract the numbers including the decimal point? Please see attached example.
Many thanks.
Posted : 30/09/2023 7:36 am
In the Added Custom step, allow for the decimal point to be included.
Text.Select([Values],{"0".."9", "."})
Then change the data type for the 'Numbers Only' column to decimal number. This will create errors on all rows that contain only a decimal point. Right-click the column header and Replace Errors. Replace these errors with null. Close and load.
Posted : 30/09/2023 8:39 am
