
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 :

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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},"\"","")

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 04, 2023 10:01 AM
Unfortunately, it didn't work
