� REPLACEMENT CHARACTER used to replace an unknown, unrecognized or unrepresentable character

[Anonymous]

How can I filter out the unknown charater � in a dataset row if Power Query and Front End Power BI do not recognize the symbol as a null or a known character to identify and filter out?

[ChrisMendoza · Accepted solution]

@Anonymous,

I'll be honest, all I did was copy and paste the symbol, it seems to work in that instance. Hopefully that will work for you.

Replacer.ReplaceText ( [Column1], "�", ", it's gone, ")