Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear Community
I am pulling facebook lead ads into PQ.
There is some coincidences where people have emojies in there name.
I am using: Text.Select([First Name],{"a".."z","A".."Z","0".."9"," "}
When I am using this formula it also removes the æ ø å from people names in Denmark.
How can I keep Æ Ø Å æ ø å?
Anders 🧚🏽♀️
Hans Sjøtlov
Solved! Go to Solution.
Hi Anders,
The quickest solution is probably to add in all the characters you want to keep to your selectChars argument
(everything in the curly braces). To keep the characters you've mentioned, your Text.Select line would look like:
Text.Select([Column1],{"a".."z","A".."Z","0".."9"," ", "Æ", "Ø", "Å", "æ", "ø", "å"})
Or you can try by referencing to this Unicode characters table with
Text.Select([First Name],{"a".."z","A".."Z","0".."9"," ", "À".."ÿ"})
Hi Anders,
The quickest solution is probably to add in all the characters you want to keep to your selectChars argument
(everything in the curly braces). To keep the characters you've mentioned, your Text.Select line would look like:
Text.Select([Column1],{"a".."z","A".."Z","0".."9"," ", "Æ", "Ø", "Å", "æ", "ø", "å"})
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.