How to remove 1), 2), 3) ...10) text from program titles

[hellyars]

I have a field "programTitle".   Unfortunately, programTitle my or may not have a number and parentheses in front of the actual title.   For example, 1) Program Title, 2) Program Title....10) Program Title. I want to get rid of theses.   A LEFT ([programName], 2) does not work because it misses 10), 11), 12)....

Update -->.  I want to remove any instance of 1), 2)...10).  But, there may a later instance of ")" in the actual programName if an acronym is used.  I don't want to loose that. 

Any thoughts?

[MarqueeCrew · Accepted solution]

Would you like to try with a regular expression or without?

RegEx_Replace([Program Title], "\d+\)\s*(.*)",'$1')

That will find anything after 1 or more numbers followed by the end parenthesis ')' character plus 1 or more spaces.

Trim(Substring([Program Title],FindString([Program Title], ')')+1))

That finds the first end parenthesis (zero-based counting) and then gets everything after it.  That result is then TRIMmed to remove spaces before and after it.

Cheers,
Mark

[ivoller · Accepted solution]

 Formula Tool with something like REGEX_Replace([Field1], "\d+\) ", "") should work

Iain

[fevizcaino · Accepted solution]

See attached solution.

Hope it helps.

Fernando Vizcaino

[ivoller]

Mark's (@MarqueeCrew) answer is more comprehensive than mine.

[hellyars]

Both work great.  Thanks.