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.

Removing Bracketed Text

Topic Labels: Formulas
Solved
Jump to Solution
2641 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Matt_Grzan
5 - Automation Enthusiast
5 - Automation Enthusiast

I feel like what I’m trying to do is simple, but I just can’t make it work.

I want to remove the text in the brackets. Example below:

[SUPV PROD - STAFF] Doe, John
[SrDesign/Ani - FL] Doe, Alice
[PRO/EDITOR - Ani] Smith, David

I want to remove the all the text in the bracket and the brackets themselves. Desired results below:

Doe, John
Doe, Alice
Smith, David

The Bracketed text is always in the beginning of the string.
Thanks!

1 Solution

Accepted Solutions
Mohamed_Swella1
13 - Mars
13 - Mars

Hi @Matt_Grzan,

Welcome toi Airtable Community !

I have found this topic answer that might help you

The below modified answer to fit your requirements is working.

IF(FIND("[", MID({Name}, FIND("]", {Name}) + 1, 20)), MID(MID({Name}, FIND("]", {Name}) + 1, 20), 1, FIND("]", MID({Name}, FIND("]", {Name}) + 1, 20)) - 1), MID({Name}, FIND("]", {Name}) + 1, 20))

BR,
Mo

See Solution in Thread

3 Replies 3
Mohamed_Swella1
13 - Mars
13 - Mars

Hi @Matt_Grzan,

Welcome toi Airtable Community !

I have found this topic answer that might help you

The below modified answer to fit your requirements is working.

IF(FIND("[", MID({Name}, FIND("]", {Name}) + 1, 20)), MID(MID({Name}, FIND("]", {Name}) + 1, 20), 1, FIND("]", MID({Name}, FIND("]", {Name}) + 1, 20)) - 1), MID({Name}, FIND("]", {Name}) + 1, 20))

BR,
Mo

This is Awesome! Works perfectly. Thank you!!

This could be greatly simplified. The pattern I see is that you want to keep everything starting with the second character after the closing bracket, which leads me to this formula:

IF(FIND("]", Name), TRIM(RIGHT(Name, LEN(Name) - FIND("]", Name), 50)))

Screen Shot 2020-03-18 at 9.46.38 PM

Assuming that you don’t have any names longer than 50 characters, this will do.