Forum Discussion
GregBeaumont
Advocate II
Advocate IIA Simple Method to Filter Text Strings in Query Editor
Using M in Query Editor, I'm looking for a simple and efficient means by which to remove non-letters from a text column in a table. For example, if the first two rows within a column have values "thi...
No need to lowercase. Try this:
Text.Remove(..YourText.., List.Transform({0..64, 91..96, 123..50000}, each Character.FromNumber(_))))
This will remove every character within the range of 0..50000 that isn't a..z or A..Z. So if you have some special signs that you want to include, you need to find the number (Character.ToNumber) and include those numbers in the list above.
pfuschi
Advocate I
Advocate IHi Imke
This also removes characters written in non-latin alphabetics....
Any suggestions?
ImkeF
Community Champion
Community ChampionYou need to find the corresponding numbers to these characters. Easiest might be to create a " translation-table", load it to excel and then search & Identify your ranges: Create a list: {1..50000}, convert to table and add a column: Character.FromNumber([ColumnName]).