Hi guys,
I wonder if someone can help. I have a description field has lots of data and in the data there is a pair of brackets and inside it a Dx code. This is an outcome of clinical pathway so the code could be (Dx21) or (Dx409).
I used the
LeftBracket: InStr([Description],"(") to find the left bracket and
RightBracket: InStr([Description],")")
to find the right bracket but I have no idea how to return the in between.
If the code was (Dx00) then it is easy but sometimes it is (Dx000).
Any help please would be appreciated.
Regards
Wessam