Hi I have an excel sheet where results of multiple angiograms of a given patient are concatenated into a single cell. The variable name of this cell is "cardiac_cath". There are thousands of patients in this excel sheet, with several thousand other variables.
In "cardiac cath" of this patient, there are results from 3 angiograms, separated by "|".
Each angiogram contains stenosis percentages of up to 4 coronary vessels:
I would like to extract this into variables:
date1, LAD1, RCA1, LM1, LCX1 (for first angiogram), where they have the values of 2003-07-15, 60, 0, 0, 70, respectively
date2, LAD2, RCA2, LM2, LCX2 (for second angiogram), where they have the values of 2003-11-24, 40, 0, 90, 95, respectively
would like to learn from you a code that can do this for all the patients on the excel
thanks so much in advance
... View more