Forum Discussion
How to remove any non-numerical characters
Found a couple of answers on this but none that fit my issue - I'm working with data that's been entered into a free text field, and it's a bit of a nightmare. The easiest way to clean it up will be ...
Anonymous,
In Power Query, create this custom column. The ranges such as 32 - 47 refer to ASCII characters.
Text.Remove( [DT Number], { Character.FromNumber(32) .. Character.FromNumber(47), Character.FromNumber(58) .. Character.FromNumber(255) } )In PQ, in a custom column, you can use below formula
= Text.Select([DT Number],{"0".."9"})If you want to look at only first 9 characters of extracted numbers
= Text.Start(Text.Select([DT Number],{"0".."9"}),9)
DataInsights
Super User
Super UserAnonymous,
In Power Query, create this custom column. The ranges such as 32 - 47 refer to ASCII characters.
Text.Remove(
[DT Number],
{
Character.FromNumber(32) .. Character.FromNumber(47),
Character.FromNumber(58) .. Character.FromNumber(255)
}
)
This also works, thank you!