Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Data corruption when using LEN and FIND with emoji's

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

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

LENvsFIND

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