
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 27, 2019 04:00 AM
Hi,
I am looking for a formula to remove text between parentheses.
For exemple, I would like to have :
Le nord (Chili) > Le nord
Le nord (Soudan) > Le nord
Le sud (Soudan) > Le sud
Thanks in advance for your help :slightly_smiling_face: !
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 27, 2019 09:20 AM
Two things…
- I didn’t double-check my parentheses and left too many in there. Fixed above.
- When referring to a field with spaces in its name, Airtable requires you to wrap curly braces around the field name.
With these fixes in place, your formula should be:
IF(FIND("(", {Nom complet}), LEFT({Nom complet}, FIND("(", {Nom complet}) -1), {Nom complet})

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 27, 2019 04:12 AM
Like this?
Formula…
LEFT(Name, FIND("(", Name) -1)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 27, 2019 04:18 AM
Great, thanks a lot !

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 27, 2019 04:31 AM
But if I don’t have any parentheses, there is no more text …

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 27, 2019 05:49 AM
A slight modification takes care of that:
IF(FIND("(", Name), LEFT(Name, FIND("(", Name) -1), Name)
EDIT: Removed extra parentheses.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 27, 2019 07:34 AM
Thanks for your help but it seems that something is missing…
IF(FIND("(", Nom complet)), LEFT(Nom complet, FIND("(", Nom complet) -1), Nom complet))

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 27, 2019 09:20 AM
Two things…
- I didn’t double-check my parentheses and left too many in there. Fixed above.
- When referring to a field with spaces in its name, Airtable requires you to wrap curly braces around the field name.
With these fixes in place, your formula should be:
IF(FIND("(", {Nom complet}), LEFT({Nom complet}, FIND("(", {Nom complet}) -1), {Nom complet})

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 27, 2019 09:32 AM
Perfect, thanks a lot for your help !!
