The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Re: Emojis counting double in string formulas counts?
Hi,
I amm having a strange issue with MID(X,1,5) returning more than 5 characters and LEFT(XX,10) returning more than 10 :slightly_smiling_face:
Is this a known issue ? Any clue to make it work ? See attached screens
Valérian LEBERT
Accepted Solutions
Yes emoji sometimes are tricky and counts double because there are encoded on 2 octets.
I got it:
:white_large_square: and :black_large_square: are not “emojis” because they exists in ASCII
:yellow_square: is emoji.
In my case the only workaround is to use only ASCII characters
or only emojis (that is colored squares) and double the value in MID or LEFT
Yes emoji sometimes are tricky and counts double because there are encoded on 2 octets.
I got it:
:white_large_square: and :black_large_square: are not “emojis” because they exists in ASCII
:yellow_square: is emoji.
In my case the only workaround is to use only ASCII characters
or only emojis (that is colored squares) and double the value in MID or LEFT
