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.

Extract Text from between Brackets in a Single Line Text field

Topic Labels: Formulas
Solved
Jump to Solution
2683 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Jaap_Terheggen
4 - Data Explorer
4 - Data Explorer

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
Bill_French
17 - Neptune
17 - Neptune

Hi @Jaap_Terheggen, and welcome to the community!

Like this?

image

Solution:

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

image

See Solution in Thread

2 Replies 2
Bill_French
17 - Neptune
17 - Neptune

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.