Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Extract Text from between Brackets in a Single Line Text field

Topic Labels: Formulas
Solved
Jump to Solution
752 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi there,

unfortunately, I have not yet found an answer to my question in this forum so I am asking myself. I have a single line text cell which is always structured similarly to the following:

Brand Name Product Name (Color / Color / Color)

I would like to extract only the portion in between the brackets into another cell. Meaning my output would be

Color / Color / Color

Unfortunately, the number of characters before the first bracket and within the brackets will vary. That is my main concern and why I have not yet found a good formula to fix this.

Any help is very much appreciated. Thanks in advance!

1 Solution

Accepted Solutions

Hi @Jaap_Terheggen, and welcome to the community!

Like this?

image

Solution:

REGEX_EXTRACT({RegEx Examples}, '\\((.*?)\\)')

image

See Solution in Thread

2 Replies 2

Hi @Jaap_Terheggen, and welcome to the community!

Like this?

image

Solution:

REGEX_EXTRACT({RegEx Examples}, '\\((.*?)\\)')

image

Yes, this is exactly it. Thank you so much.