Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Fx field showing ""

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

I have a Fx field and for some reason, it’s showing " at the beginning and end of the words. Is there a way to remove it?

Formula: {Contact} & “—” & {Type}

How it’s showing: “John Smith, Acme Inc”—Email

How I’d like it to show: John Smith, Acme Inc — Email

1 Reply 1

Welcome to the Airtable community!

Is {Contact} a linked record field? Airtable adds these quotes around a linked record field value when there is a comma or other special character in the primary field value.

If you know that there will only ever be quotes added by Airtable, and no quotes that you actually want to keep, you can use `SUBSTITUTE()

CONCATENATE(
    SUBSTITUTE({Contact} & '', '"',''),
    "—",
     {Type}
)

If your the primary field of the linked record might contain a quote that you want to retain, and there is only ever one linked record, you need a much more complex formula. The formula is actually so complex that I included it as a premium formula in my Ready Made Formulas app.