Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Remove quotation marks in ID

Topic Labels: Formulas
1292 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