Forum Discussion

hood2media's avatar
hood2media
Icon for Resolver II rankResolver II
3 years ago
Solved

power query | remove special characters

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
Need Help
Show and Tell
  • JorgePinho's avatar
    JorgePinho
    3 years ago

    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"," ", "?"}))

     

     

     

JorgePinho's avatar
JorgePinho
Icon for Solution Sage rankSolution Sage
3 years ago

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"," ", "?"}))