Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Replace String

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

3 Posts

2 Users

0 Reactions

61 Views

RSS

ljburnham

(@ljburnham)

Posts: 331

Reputable Member

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

ken.takenaka

(@ken-takenaka)

Posts: 212

Reputable Member

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

ljburnham

(@ljburnham)

Posts: 331

Reputable Member

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

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0