Help

Remove quotation marks in ID

Topic Labels: Formulas
601 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Les_Gros_Becs
6 - Interface Innovator
6 - Interface Innovator

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!
2 Replies 2
Sho
11 - Venus
11 - Venus

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