Skip to main content

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!

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

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


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

Reply


Terms & Conditions