Text.Select - No Emojis but keep æ ø å

[asamr]

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

[Jakinta]

Or you can try by referencing to this Unicode characters table with

Text.Select([First Name],{"a".."z","A".."Z","0".."9"," ", "À".."ÿ"})

[AlanHarman-Box · Accepted 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"," ", "Æ", "Ø", "Å", "æ", "ø", "å"})