extract data in text string

[lori poteet]

Please help! I'm trying to build a query where I'm
extracting data in a text string. The data I want is
inside the parenthesis within the text string and can
vary it's position. How do I build this query?
Examples:
1. Parachutist (amuse. & rec)
2. Registered Nurse (Med. serv)alternate RN

 

[Dale Fye]

Lori,

Because the possibility exists that you might be missing a left or
right paren, or that they might not be in the correct order, I think I
would probably write a function to do this for me. That way, if the
record did not fit the pattern I expected, I could return a value that
would allow me to readily identify those records quickly.

--
HTH

Dale Fye


Please help! I'm trying to build a query where I'm
extracting data in a text string. The data I want is
inside the parenthesis within the text string and can
vary it's position. How do I build this query?
Examples:
1. Parachutist (amuse. & rec)
2. Registered Nurse (Med. serv)alternate RN