I am looking to parce out only the text before a specific word or combination of words in the script. In particular, I am looking to parce out and create a new field everything before either W/O CC/MCC or W CC or W MCC in the subset of data below. When done this would create a new field with CRANIOTOMY & ENDOVASCULAR INTRACRANIAL PROCEDURES (for DRG 25-27) and SPINAL PROCEDURES (for DRG 28-30). Any help would be greatly appreciated.
CRANIOTOMY & ENDOVASCULAR INTRACRANIAL PROCEDURES W MCC
CRANIOTOMY & ENDOVASCULAR INTRACRANIAL PROCEDURES W CC
I gues that you are looking to get rid of the last portion, but what is the requirement for the new column you need? I am not sure I understand that part of the thread? Would you be able to put down the required output for the above data you have provided?