My data source is an Excel spreadsheet. I have measure names that are in a cell that also has the name of the Department in parenthesis.
Example:
% Cancellations Day of Surgery-PSL (Main OR)
% Cancellations Day of Surgery-PSL (Perioperative Services)
% Change in Overall Pain Score Intensity - Pain Clinic (Ambulatory Care Center)
Is there a way to extract the Department name contained within the parenthesis so that I could sort ascending by Department Name so measures are displayed in Department Name ascending order (e.g. Ambulatory Care, Main OR and then Perioperative Services)?
I have about 300 different measure names and approximately 40 different Department Names.
I am using CR10.
Example:
% Cancellations Day of Surgery-PSL (Main OR)
% Cancellations Day of Surgery-PSL (Perioperative Services)
% Change in Overall Pain Score Intensity - Pain Clinic (Ambulatory Care Center)
Is there a way to extract the Department name contained within the parenthesis so that I could sort ascending by Department Name so measures are displayed in Department Name ascending order (e.g. Ambulatory Care, Main OR and then Perioperative Services)?
I have about 300 different measure names and approximately 40 different Department Names.
I am using CR10.