I have the need to generate a drop-down list containing referring physicians. This is available using the REGPROVIDER("refphys","","list") function but it returns results with commas which of course blows up the drop-down list. Programmatically I can see how to do a while loop using match and set to replace the commas but my programming experience wants me to assign it to a variable and I can't quite figure out how to do that as a MEL expression in the MEL editor in the VFE. Can anyone give me some code samples or ideas I can plagiarize to get where I need to go?
Perhaps you could just use the data symbol: replacestr and replace the commas with nothing - empty quotes, or replace them with semicolons, and then in the chart note translation, use replacestr again and replace the semicolons with commas.
replacestr(myresult, ",","")
or
replacestr(myresult, ",",";")
cfmt(replacestr(myresult, ";",","), "", "Phyisicnans: ","B",".........
See this topic:
https://centricityusers.com/?page_id=.....e=dropdown comma&type=1&include=1&search=1
REPLACESTR(REPLACESTR(PROB_PRIOR("list"), ",", "\,"), hret, ",")
works for problems that contain commas. You could try:
REPLACESTR(REPLACESTR(REGPROVIDER("refphys","","list"), ",", "\,"), hret, ",")
Thanks, that got me thinking in the correct direction. Ended up using a couple of renditions of
REPLACESTR(REPLACESTR(regprovider("refphys","","delimited"), "^", " "),"|",HRET)
replacing hte HRET with a comma for drop down lists. Never thought to nest the Replacestr
function. I appreciate it!!
Greg