Help

Removing Bracketed Text

Topic Labels: Formulas
Solved
Jump to Solution
2383 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.