Notifications
Clear all
Topic starter
I have been using {APPTS_BY_STATUS("no show", "FULL")} for no show letters but the patients are confused by some of our terminology within the "FULL" pull of information. I would like to remove the appointment type from it but have no idea how to do it.
Any thoughts?
thanks
Posted : September 20, 2016 5:56 am
Here is something to give you the concept. You have to look for the 2nd and 3rd commas and concatenate the string before the 2nd with the string after the 3rd. You will have to turn the APPTS_BY_STATUS into an array and loop through it, doing something like this to each row:
strApptList = "06/02/2016, 11:00 AM, Est Office 15 min, Eastside Internal Medicine, Robin C. Janoff MD"
strApptTypeStart = match(strApptList,"M,")
strApptListStart = sub(strApptList,1,strApptTypeStart)
strApptTypeEnd = match(strApptList,strApptTypeStart + 3, ", ")
strApptListEdit = strApptListStart + sub(strApptList,strApptTypeEnd)
returns:
06/02/2016, 11:00 AM, Eastside Internal Medicine, Robin C. Janoff MD
Posted : September 20, 2016 7:38 am
Topic starter
perfect, thank you!
Posted : September 21, 2016 3:55 am
