Help

Fx field showing ""

Topic Labels: Formulas
730 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Paulo_Galletti
4 - Data Explorer
4 - Data Explorer

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.