Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Data corruption when using LEN and FIND with emoji's

Topic Labels: Formulas
129 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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