Extract data in between parentheses 1

[Terpsfan]

I have a text field where I have data in between parentheses, like (TIPS) I would like to just extract the data from the parentheses. Does anyone have an example of how this works? I'm assuming you use a combination of mid and instr, but not sure how. Thanks

 

[PaulBricker]

This should do it.

=Mid([DataField],2,Len([DateField])-2)

Paul

 

[mwolf00]

SELECT mid(textField, indexOf(textField,"("), indexOf(textField, ")") - indexOf(textField,"(")) FROM myTable

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

Tsuna​

 

[PHV]

Mid([Field name],InStr([Field name],"(")+1,InStr([Field name],")")-InStr([Field name],"(")-1)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Terpsfan]

Thanks for your Responses.

What I ended up doing was this, because the field always begins with a parentheses:

Mid$([FieldName],2,(Instr(2,[FieldName],")")-2))

 

[Terpsfan]

Thanks PHV, your solution was actually better, because it parses out the string wherever the parentheses are in the field.