Query for counting emojis in texts

SQL++
1

Hello,
I am currently trying to write a query to count all occurrences of emojis in texts. My documents look like this:

doc1:{
    'docType': 'message',
    'text': 'some string that might have emojis here 🤔'
}

I think that my best bet would be using regex, but I have not figured out what the regex would be and how I could use it in my query (I tried to look up a few regex for emojis online but they do not seem to work as I want). Thank you so much in advance.

2

Check if TOKENS() will help
https://docs.couchbase.com/server/5.5/n1ql/n1ql-language-reference/tokenfun.html#fn-str-token
Also checkout FTS Search