Forum Discussion
CharleyKirton
3 years agoFrequent Visitor
Remove Emojis from Open Text Field
Hi all! I have over 800k rows of open text data from a range of sources including social media. I need to remove (pesky) emojis. One single message contains 55 different emojis like the person ...
CharleyKirton
3 years agoFrequent Visitor
Aww - thank you for trying!!
Unfortunately when I said I'm using Power Query, it's actually as a dataflow (which later feeds an AI engine, so needs to remain a dataflow), so Python's not an option. **bleep**!! I really appreciate your help though!!
I'm now experimenting with this method: (402) Power Query: Bulk Replace Values from a table in Excel & Power BI - YouTube
CharleyKirton
3 years agoFrequent Visitor
(Ha! That bleep really was not a terrible expletive!!)
- goncalogeraldes3 years agoSuper User
Ohhh I hope that solution works for you! Sad I could not help tho! Take care 🙂