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)
Vijay_A_Verma
Most Valuable Professional
Most Valuable ProfessionalIn 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)Perfect, thank you!