Double Quote Escaped by a Double Quote


#1

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


How to include quotation marks in the formula field