
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 07, 2022 10:22 PM
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! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 08, 2022 06:05 AM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 08, 2022 01:08 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 08, 2022 06:05 AM
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
