Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm analyzing data about incoming emails and one of the questions is: "Is there any emoji in the subject?". I have subjects in separate column but cant find any suitable solution for checking emojis in string.
Any idea?
Thanks 🙂
Solved! Go to Solution.
HI @robertj,
I think it is hard to analytic, normally these specific character will store as particular format or unicode characters.(e.g. power bi community will analysis colon and some specific word as emoji.)
I'm not so clear for email contents which you mentioned, maybe you can send a sample email with all available emoji in with separator, then you can choose that email to compare with original analytics email contents to create a dictionary table for each emoji.
Regards,
Xiaoxin Sheng
HI @robertj,
I think it is hard to analytic, normally these specific character will store as particular format or unicode characters.(e.g. power bi community will analysis colon and some specific word as emoji.)
I'm not so clear for email contents which you mentioned, maybe you can send a sample email with all available emoji in with separator, then you can choose that email to compare with original analytics email contents to create a dictionary table for each emoji.
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |