Help

Emojis counting double in string formulas counts?

Topic Labels: Formulas
Solved
Jump to Solution
126 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

Labels