extract data in text string

  • Thread starter Thread starter lori poteet
  • Start date Start date
L

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
 
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
 
Back
Top