Skip to main content

Remove quotation marks in ID

  • July 6, 2023
  • 2 replies
  • 56 views

Forum|alt.badge.img+7

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

Forum|alt.badge.img+21
  • Inspiring
  • July 7, 2023

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},"\\"","")

 


Forum|alt.badge.img+7
  • Author
  • Known Participant
  • August 4, 2023

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