S
Springman
I have a set of [Drug_name] records as follows:
Lipitor tab 20 mg
Tylenol cap 500 mg
I need to extract text to the left of the words "cap" or "tab". If "cap" or
"tab" is not present in the string, I'd like the recoord to remain unchanged.
Any suggestions would be appreciated.
Lipitor tab 20 mg
Tylenol cap 500 mg
I need to extract text to the left of the words "cap" or "tab". If "cap" or
"tab" is not present in the string, I'd like the recoord to remain unchanged.
Any suggestions would be appreciated.