Query Out Specific Text

[ysabella]

I need to write a query that will eliminate text to the left of parenthesis and leave just what is in the parenthesis. For example:



Original: ABC Company (Doe, Jane)

Needs to be: (Doe, Jane)

I have numerous companies and the only constant is the information is in parenthesis. I can easily remove this using a “find and replace” in the table but need to be able to do this using a query. I appreciate any assistance – thank-you!

[jobbie]

try this:

Expr1: Mid([Field1],InStr([Field1],"("),InStrRev([Field1],")")-InStr([Field1],"(")+1)