Forum Discussion
rajeshchawla
Helper I
Helper IHow to remove all characters except alpha numeric in text column
The column is populated with data that contains quite a few Unicode characters. The rows of interest to me are the ones where the characters are only in the range of a-z (upper or lower case) or 0-9....
Here is one way of doing it. The below code filters rows to only those where Text is equal to just the alphanumeric characters from Text.
This assumes the last step of the query is PreviousStep and the column of interest is named Text.
= Table.SelectRows( PreviousStep, each [Text] = Text.Select([Text],{"a".."z","A".."Z","0".."9"} ) )Regards,
Owen
OwenAuger
Super User
Super UserHere is one way of doing it. The below code filters rows to only those where Text is equal to just the alphanumeric characters from Text.
This assumes the last step of the query is PreviousStep and the column of interest is named Text.
= Table.SelectRows( PreviousStep, each [Text] = Text.Select([Text],{"a".."z","A".."Z","0".."9"} ) )Regards,
Owen
- rajeshchawla
Thank you!
