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
Solved
Emojis counting double in string formulas counts?
+2Best answer by Valerian_LEBERT
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.
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
+29Welcome 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.
+2Welcome 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.
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
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.