Forum Discussion

hood2media's avatar
hood2media
Resolver 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"," ", "?"}))

     

     

     

2 Replies

  • JorgePinho's avatar
    JorgePinho
    Solution 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"," ", "?"}))