Skip to main content

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 🙂


Is this a known issue ? Any clue to make it work ? See attached screens





Valérian 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.

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:

⬜ and ⬛ 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


Reply


Terms & Conditions