how to split a string column into 4 string columns?
I have definition column of a medication. I want the definition to be
split into [product name(PN)], [doseform(DF)], [total dose(TD)] and
[units]. Eg:
BENADRYL: MYLANTA 1:1 SOLUTION(Benadryl
mylanta(PN),Sol(DF),1:1(TD),NULL(units))
MASK AND SPACER (Mark and Spacer(PN),NUll,NUll,NUll)
BL VITAMIN B-6 50 MG TABS(BL Vitamin(PN),Tabs(DF),50(TD),MG(Units))
No comments:
Post a Comment