Notifications
Clear all
Topic starter
I am trying to modify a lab results letter (that I originally received from this forum). We now have an interface with 2 outside lab. When we went live with the first lab I was able to add a ReplaceStr to the result and strip out the units. Now the 2nd lab uses different units, how do I strip those out:
+ ReplaceStr(AnyInDays("WBC K/UL", 21, " WBC: ", "", "", " (Normal: ", "103712", "", "")," THOUSAND/UL","")
The THOUSAND/UL is from the 1st lab. The second lab uses X10E3/UL. I can't figure this one out.
Thanks in advance.
Laurie
Posted : November 3, 2015 8:12 am
I don't know what kind of function definition you are using for AnyInDays() but wouldn't it just be
ReplaceStr(AnyInDays(“WBC K/UL”, 21, ” WBC: “, “”, “”, ” (Normal: “, “103712″, “”, “”),” X10E3/UL”,””)
Posted : November 3, 2015 8:42 am
Topic starter
Thanks Ken
I actually learned that I needed to nest the replacestr:
+ ReplaceStr(ReplaceStr(AnyInDays("WBC K/UL", 21, " WBC: ", "", "", " (Normal: ", "103712", "", "")," THOUSAND/UL","")," X10E3/UL","")
Thanks to my ever so smart co-worker Ron.
Laurie
Posted : November 3, 2015 9:13 am
