Display only certain characters within a string 1

[meagain]

I need to display only characters between the () in a field. The bracketed portion is always at the end of the string, but varies in length.

ie:

String Result Required

lori123(hellodolly) hellodolly
lori567(hellolu) hellolu

I'm sure I've done this before, but for the life of me I can't remember how.

Thank you for your assistance

 

[Remou]

You can use Mid and Instr.

 

[PHV]

Something like this ?
Mid(Left(yourString,InStr(yourString,")")-1),InStr(yourString,"(")+1)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[meagain]

Thanks, that was right on the money for what I requested. However, the plot now thickens :-D. There is one string that the user has set up with 2 bracketed parts. Here is the scenario with the current results and the results I need.

ie:

String Result Result Required

lori890(hello)(dolly) hello dolly

The current formula is :Mid(Left(yourString,InStr(yourString,")")-1),InStr(yourString,"(")+1)

Thanks again for your assistance.

 

[PHV]

Replace InStr with InStrRev

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886