Re: Emojis counting double in string formulas counts?

Valerian_LEBERT · ‎Sep 07, 2022

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

Valerian_LEBERT · ‎Sep 08, 2022

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

kuovonne · ‎Sep 08, 2022

Welcome to the Airtable community!

This is a strange bug. I have not see it before although I have seen cases where emoji mess up character counts.

Can you share the base?

I also suggest asking Airtable support for help.

Valerian_LEBERT · ‎Sep 08, 2022

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