Unwanted quotation marks in pulled through by formula


#1

I have a formula that pulls text from another field. That field is a link to another table. Airtable is creating quotation marks around the text if the text contains any punctuation marks. Is there a way of stopping this??


#2

What is your formula? Or what are you trying to do?


#3

That’s Airtable’s default behavior when accessing a text field with embedded punctuation. I know of no way to prevent it from happening — but you could always wrap your formula with something like

MID({Text},2,LEN({Text})-2)