Extract specific string text within Parentheses

[wrigst]

Hi All,

Recently joined this forum and searched for the answer tono avail (apologies now if the answer is here in another thread).

I have a field with a short text string that looks like this: "lastname, firstname (domain\username)". I want to extract the "username" portion of this text into a separate field. I have tried using the following expression, but I am left with the trailing parentheses:

Expr: Mid[fieldname], InStr([fieldname],"")

So I am getting what I asked for, but with extras! Is there another way to use the InStr function to omit the trailing parentheses or perhaps a completely different expression?

Thanks in advance

 

[sxschech]

Something like this?

replace(mid([fieldname],instr([fieldname],"(")+1),")","")

 

[wrigst]

Thanks sxschech - I seem to get an error with this expression "The expression you entered has a function containing the wrong number of arguments) - any ideas?

Appreciate your help guys

 

[wrigst]

Thanks sxschech - I just realised that I had typed in your expression with a typo. Your solution worked perfectly - Many Thanks!!

 

[sxschech]

You're welcome. Glad it worked.