Is there any emoji in the string?

[robertj]

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 🙂

[v-shex-msft · Accepted 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