Data corruption when using LEN and FIND with emoji's

Topic Labels: Formulas
530 1
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

Airtable is measuring emoji length differently under functions LEN and FIND.


In the screenshot, the two fx fields have the formula as the field name.
With LEN, Airtable is measuring the length of “ :stop_sign: 23” as 3 [as if :stop_sign: =1].
With FIND, Airtable is saying the position of the “3” is at position 4 [as if :stop_sign: =2].

Emojis have differing character lengths, but it should be consistent within Airtable.
When using LEN & FIND to extract data from an array, the results fail. In a large array, adjusting with a ‘remove the emoji>then put it back’ strategy is a huge sloppy mess.
Any better ideas?

1 Reply 1