Unanswered: Is it possible to extract only bracketed portion of text field using query?
hi folks, I have a text field which contains a mixture of information that is bracketted and not bracketted, with random numbers of characters. Here are examples of 2 records:
HPV145 (REVD HV114)
HDKLLLDKFKKK (REVD HD1) KDOLL
What I want to do is write a query that would extract
If this cannot be done using access, is there perhaps an excel function that could do it? closest I could get was using FIND (*), which accurately found each set of bracketted info, but no idea how to do a mass extraction (its about 4000 records). Am I SOL, or does someone know a way to do it with some code?
"if '(' is found, then if ')' is found, then take the substring starting 1 character beyond the '(' and going for a length calculated by the position of the ')' minus the position of the '(' minus 1.... otherwise return nothing... otherwise return nothing"
this one don't
this one (does) does
(at the front) eh at the front
in (the middle) eh the middle
at (the end) the end
two (of) (them) of