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

Double Quote Escaped by a Double Quote

Topic Labels: Formulas
2274 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Multi-select fields containing a value with a " (double quote) in it yield unexpected results with formulas—essentially because Airtable seems to escape double quotes in arrays with another double quote rather than a backslash or something else.

Here’s a series of formula results on a multi-select field named {multi} containing a single option with the value: 6" Bar Pull

Formula: {multi}
Result: “6"” Bar Pull"

Formula: FIND('6" Bar Pull",{multi})
Result: 0

Formula: FIND(‘6" Bar Pull’, REPLACE(multi, FIND(’""’, multi), 2, ‘"’))
Result: 2

c2d7ffa73dd6c6c9325eaf8721636cf8e9a611e5.png

0 Replies 0