power query | remove special characters

[hood2media]

hi,

ref sample file here.

i'd appreciate any help to remove the special characters (emojis) that appear in multiple locations in the sample file - using power query preferably.

tks & krgds, -nik

[JorgePinho · Accepted solution]

Hello @hood2media !

I archieved it adding the following line on Advanced Editor:

#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Text.Select([Column1],{"a".."z","A".."Z","0".."9"," ", "?"}))

[hood2media]

many tks, @JorgePinho.
krgds, nik