Extract data between brackets

[AndyDevine1]

Hi there

What is function to extract data between brackets?

eg extract dogs from some_text_[dogs]_more text

Many thanks

Andy

 

[XOR LX]

Hi.

So there's only ever one occurrence of both a "[" and a "]" in the string? If so:

=MID(A1,FIND("[",A1)+1,MMULT(FIND({"[","]"},A1),{-1;1})-1)

Regards

 

[AndyDevine1]

Hi, thanks for your reply, that looks like an Excel formula, not Access? (i did try using my field names, just in case, but couldn't get it to work)...do you know Access version for this formula?
thanks
A

 

[XOR LX]

Sincere apologies. I didn't realise you'd posted in the Access section.

Regards

 

[Marbles]

The last post on this page seems to work okay:

Extract Text Between Parentheses - Access World Forums

 

[AndyDevine1]

many thanks guys. works a treat!