Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 06, 2023 12:33 PM
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 :
Jul 06, 2023 06:29 PM
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},"\"","")
Aug 04, 2023 10:01 AM
Unfortunately, it didn't work