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.

Looking for a formula to remove text between parentheses

Topic Labels: Formulas
Solved
Jump to Solution
4804 7
cancel
Showing results for 
Search instead for 
Did you mean: 
Thibaud_Donzier
6 - Interface Innovator
6 - Interface Innovator

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: !
Capture d’écran 2019-12-27 à 12.55.41

1 Solution

Accepted Solutions

Two things…

  1. I didn’t double-check my parentheses and left too many in there. Fixed above.
  2. 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})

See Solution in Thread

7 Replies 7

Like this?

image

Formula…

LEFT(Name, FIND("(", Name) -1)

Thibaud_Donzier
6 - Interface Innovator
6 - Interface Innovator

Great, thanks a lot !

Thibaud_Donzier
6 - Interface Innovator
6 - Interface Innovator

But if I don’t have any parentheses, there is no more text …

Capture d’écran 2019-12-27 à 13.28.36

A slight modification takes care of that:

IF(FIND("(", Name), LEFT(Name, FIND("(", Name) -1), Name)

EDIT: Removed extra parentheses.

Thanks for your help but it seems that something is missing…

IF(FIND("(", Nom complet)), LEFT(Nom complet, FIND("(", Nom complet) -1), Nom complet))

Capture d’écran 2019-12-27 à 16.33.29

Two things…

  1. I didn’t double-check my parentheses and left too many in there. Fixed above.
  2. 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})

Perfect, thanks a lot for your help !!