I have an email tracking app where I receive HTML of email body and subject from different brands through a webhook which I store in a text field.
First, I want to check if emojis are present in the subject. If yes then I would like to mark “Yes” in my Yes/no field.
Secondly, I want to somehow show in UI what are the common emojis used by a specific brand in their email along with their count.
Not sure how would I extract all emojis, store them somewhere so that I can count the use of an emoji, and create a table listing emojis of a brand sorted by count of occurrence.
Can somebody please help me achieve this with Bubble?