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

Upper/Lower Case translation

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

4 Posts

2 Users

0 Reactions

81 Views

RSS

ChrissieS

(@chrissies)

Posts: 7

Active Member

Topic starter

Our DB consists of using all CAPS in the Patient Registration fields for Name and Address. The Referring Providers table is also in ALL Caps.

We use the appropriate MEL Data Symbols, to pull in the required information, when we send letters to Referring Providers/Patients, however, as you would expect the data pulls in with the ALL CAPS format, which does not look very professional.

I am hoping that perhaps someone could offer code suggestions, that will allow this information to be converted to Upper/lower case text translation, within our letters.

Posted : April 15, 2019 9:25 am

crystalm

(@crystalm)

Posts: 7

Active Member

Hello,

We do the same thing in Registration with all CAPS and have the same issues with our letters. There are a few Mel options. You can find the Mel help in your Client file on your c-drive. CPS.help.chm.

This option capitalizes just the first initial.

{INITIALCAP(PATIENT.LASTNAME)} with last name of "SMITH"

returns

Smith

This option will make it all lowercase.

{tolower("TOLOWER")}

returns

tolower

Thanks,

Crystal - IT Systems Manager

Reno Orthopaedic Clinic

Posted : April 15, 2019 9:53 am

ChrissieS

(@chrissies)

Posts: 7

Active Member

Topic starter

Thank you so much. I had looked in the help area, but didn't see this.

It does work like a charm. I really appreciate it!!

Posted : April 15, 2019 10:25 am

crystalm

(@crystalm)

Posts: 7

Active Member

Of course. I discovered the Mel utility Functions section and it has helped me so much.

Posted : April 15, 2019 10:32 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