Help

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.

Emojis counting double in string formulas counts?

Topic Labels: Formulas
Solved
Jump to Solution
1419 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Valerian_LEBERT
4 - Data Explorer
4 - Data Explorer

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

image
image

Valérian LEBERT

1 Solution

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
image

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

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
image