Skip to main content
Solved

Looking for a formula to remove text between parentheses

  • December 27, 2019
  • 7 replies
  • 89 views
T
Forum|alt.badge.img+6

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: !

Best answer by Justin_Barrett

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

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


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})

7 replies

B
Forum|alt.badge.img+19
  • Bill_French
  • Inspiring
  • December 27, 2019

Like this?

Formula…

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

T
T
Forum|alt.badge.img+6
  • Thibaud_Donzier
  • Author
  • Known Participant
  • December 27, 2019

Great, thanks a lot !

T
Forum|alt.badge.img+6
  • Thibaud_Donzier
  • Author
  • Known Participant
  • December 27, 2019

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

Justin_Barrett
Forum|alt.badge.img+21

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


A slight modification takes care of that:

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

EDIT: Removed extra parentheses.

B
Kamille_Parks11
T
Forum|alt.badge.img+6
  • Thibaud_Donzier
  • Author
  • Known Participant
  • December 27, 2019

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))

Justin_Barrett
Forum|alt.badge.img+21
  • Justin_Barrett
  • Inspiring
  • Answer
  • December 27, 2019

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

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


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})
Kamille_Parks11
T
Forum|alt.badge.img+6
  • Thibaud_Donzier
  • Author
  • Known Participant
  • December 27, 2019

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 !!

Terms & ConditionsAccessibility statement