
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 15, 2022 12:50 PM
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?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 15, 2022 01:08 PM
From a few days ago: Emojis counting double in string formulas counts? - #2 by kuovonne
