Skip to main content

Hi all! 

In one of my bases quotation marks are added to some of my IDs that are generated through a formula (someone explained to me that it because my titles contain a comma, but I need to keep it).

I would like to remove those quotation marks. I've read and tried a lot of things, but it is not working. 

Here is my formula : 

IF({Nom pour identificateur}, {Nom pour identificateur}, Type) & " " & IF({Début}, {Début pour identificateur}) & " " & Projet
 
I also add a screenshot of my base.
 
Thank you very much for the help!

Hi @Les_Gros_Becs ,

Use the SUBSTITUTE() function to simply replace or delete characters.

Text operators and functions (Formula Field Reference - Overview | Airtable Support)

SUBSTITUTE({text},"\\"","")

 

Hi @Les_Gros_Becs ,

Use the SUBSTITUTE() function to simply replace or delete characters.

Text operators and functions (Formula Field Reference - Overview | Airtable Support)

SUBSTITUTE({text},"\\"","")

 


Unfortunately, it didn't work

Reply


Terms & Conditions