Re: [MT-L] Magic NPR Help

[Fleming, Jennifer via Meditech-L]

Thank you Les for the information! The field I am looking at has varying lengths and I would be wanting to look at whatever the last character is. Is there a way to look at that?

Thanks!

Jen


[cid:image0...@01DC0852.EB0E36B0]
[iwk-logo]

Jennifer Fleming
Lead, Encounter Management
Information Management & Technology (IM/IT)
Nova Scotia Health Authority
Tel: 902 717-2694
Jennifer...@iwk.nshealth.ca<mailto:Jennifer...@iwk.nshealth.ca>



Provincial Service Desk: 902-470-6700
Toll Free: 1-866-224-2555



Confidentiality Notice - If you have received this e-mail in error, or you are not the intended recipient, please do not open any attachments;
Notify the sender by e-mail or telephone that you have received the message, and after notifying the sender, delete the e-mail from your system.

From: Leslie Mann <lm...@linuxolutions.com>
Sent: Friday, August 8, 2025 10:46 AM
To: Fleming, Jennifer <Jennifer...@iwk.nshealth.ca>; medit...@mtusers.com
Subject: Re: [MT-L] Magic NPR Help

You don't often get email from lm...@linuxolutions.com<mailto:lm...@linuxolutions.com>. Learn why this is important<https://aka.ms/LearnAboutSenderIdentification>

** EXTERNAL EMAIL / COURRIEL EXTERNE **
Exercise caution when opening attachments or clicking on links / Faites preuve de prudence si vous ouvrez une pièce jointe ou cliquez sur un lien
Morning Jen:

An alternative to the $ string extraction operator is # which extracts the char at a specific position in a string. Note string extraction operators are zero based so the first character "occupies position zero"! Using # for your example VAL=@ee.res.rsrc.grp<mailto:VAL=@ee.res.rsrc.grp>#0

To find the last character you need to determine the length of the string, using the length function L(A) function and convert the length into the zero based position number of the last character, ie length - 1. For your new requirement try VAL=@ee.res.rsrc.grp#(L(<mailto:VAL=@ee.res.rsrc.grp>@ee.res.rsrc.grp)-1)<mailto:VAL=@ee.res.rsrc.grp>

Thanks
Les


On Fri, 2025-08-08 at 13:08 +0000, Fleming, Jennifer via Meditech-L wrote:
Hello,

I have a report where I have a computed field looking at the first letter of a mnemonic VAL=@ee.res.rsrc.grp<mailto:VAL=@ee.res.rsrc.grp>$1<mailto:VAL=@ee.res.rsrc.grp<mailto:VAL=@ee.res.rsrc.grp>$1> and I am now wondering if there is a way to do the same thing but instead look at the last letter in the mnemonic.

Thanks!

Jen


[cid:image0...@01DC084C.650F9910<mailto:image0...@01DC084C.650F9910>]
[iwk-logo]

Jennifer Fleming
Lead, Encounter Management
Information Management & Technology (IM/IT)
Nova Scotia Health Authority
Tel: 902 717-2694
Jennifer...@iwk.nshealth.ca<mailto:Jennifer...@iwk.nshealth.ca><mailto:Jennifer...@iwk.nshealth.ca<mailto:Jennifer...@iwk.nshealth.ca>>



Provincial Service Desk: 902-470-6700
Toll Free: 1-866-224-2555



Confidentiality Notice - If you have received this e-mail in error, or you are not the intended recipient, please do not open any attachments;
Notify the sender by e-mail or telephone that you have received the message, and after notifying the sender, delete the e-mail from your system.

===###===###===###===###===###===###===
To unsubscribe from the meditech-l, follow the instructions at the URL http://mtusers.com/mailman/options/meditech-l

Please do NOT send messages that ask "Please post to the list" or "I'd like to see your answers" or "Send that info to me, too" These are useless messages that just waste the email server's resources. Instead, email the original requester and ask that they send you or post the results of their question.

Go to http://MTUsers.net<http://mtusers.net/> for other information on the list, as well as:
1) reading meditech-l messages online
2) job opportunities
3) vendor products and service


Do NOT send email to meditech...@MTUsers.com<mailto:meditech...@MTUsers.com>. This is a system email box that is NOT monitored by a human. If you need help or advice on how to use the meditech-l, email ju...@MTUsers.net<mailto:ju...@MTUsers.net>, Pa...@MTUsers.net<mailto:Pa...@MTUsers.net> or And...@MTUsers.net<mailto:And...@MTUsers.net>. These list moderators help manage the meditech-l, so thay are your best resource.

===***===***===***===***===***===***===

===###===###===###===###===###===###===
To unsubscribe from the meditech-l, follow the instructions at the URL http://mtusers.com/mailman/options/meditech-l

Please do NOT send messages that ask "Please post to the list" or "I'd like to see your answers" or "Send that info to me, too" These are useless messages that just waste the email server's resources. Instead, email the original requester and ask that they send you or post the results of their question.

Go to http://MTUsers.net for other information on the list, as well as:
1) reading meditech-l messages online
2) job opportunities
3) vendor products and service


Do NOT send email to meditech...@MTUsers.com. This is a system email box that is NOT monitored by a human. If you need help or advice on how to use the meditech-l, email ju...@MTUsers.net, Pa...@MTUsers.net or And...@MTUsers.net. These list moderators help manage the meditech-l, so thay are your best resource.

===***===***===***===***===***===***===

[Fleming, Jennifer via Meditech-L]

Yes, sorry, I misunderstood. I have tried this and it worked! Thank you so much for your help! Have a great weekend 😊

Thanks!

Jen


[cid:image0...@01DC0854.112F7470]

[iwk-logo]

Jennifer Fleming
Lead, Encounter Management
Information Management & Technology (IM/IT)
Nova Scotia Health Authority
Tel: 902 717-2694
Jennifer...@iwk.nshealth.ca<mailto:Jennifer...@iwk.nshealth.ca>



Provincial Service Desk: 902-470-6700
Toll Free: 1-866-224-2555



Confidentiality Notice - If you have received this e-mail in error, or you are not the intended recipient, please do not open any attachments;
Notify the sender by e-mail or telephone that you have received the message, and after notifying the sender, delete the e-mail from your system.

From: Leslie Mann <lm...@linuxolutions.com>
Sent: Friday, August 8, 2025 11:02 AM
To: Fleming, Jennifer <Jennifer...@iwk.nshealth.ca>; medit...@mtusers.com
Subject: Re: [MT-L] Magic NPR Help

You don't often get email from lm...@linuxolutions.com<mailto:lm...@linuxolutions.com>. Learn why this is important<https://aka.ms/LearnAboutSenderIdentification>

** EXTERNAL EMAIL / COURRIEL EXTERNE **
Exercise caution when opening attachments or clicking on links / Faites preuve de prudence si vous ouvrez une pièce jointe ou cliquez sur un lien

I detailed how to accomplish that in the second paragraph...

To find the last character you need to determine the length of the string, using the length function L(A) function and convert the length into the zero based position number of the last character, ie length - 1. For your new requirement try VAL=@ee.res.rsrc.grp#(L(<mailto:VAL=@ee.res.rsrc.grp>@ee.res.rsrc.grp)-1)<mailto:VAL=@ee.res.rsrc.grp>

On Fri, 2025-08-08 at 13:55 +0000, Fleming, Jennifer wrote:
Thank you Les for the information! The field I am looking at has varying lengths and I would be wanting to look at whatever the last character is. Is there a way to look at that?

Thanks!

Jen

[cid:image0...@01DC0854.112F7470]

[iwk-logo]

Jennifer Fleming
Lead, Encounter Management
Information Management & Technology (IM/IT)
Nova Scotia Health Authority
Tel: 902 717-2694
Jennifer...@iwk.nshealth.ca<mailto:Jennifer...@iwk.nshealth.ca>



Provincial Service Desk: 902-470-6700
Toll Free: 1-866-224-2555



Confidentiality Notice - If you have received this e-mail in error, or you are not the intended recipient, please do not open any attachments;
Notify the sender by e-mail or telephone that you have received the message, and after notifying the sender, delete the e-mail from your system.

From: Leslie Mann <lm...@linuxolutions.com<mailto:lm...@linuxolutions.com>>
Sent: Friday, August 8, 2025 10:46 AM
To: Fleming, Jennifer <Jennifer...@iwk.nshealth.ca<mailto:Jennifer...@iwk.nshealth.ca>>; medit...@mtusers.com<mailto:medit...@mtusers.com>
Subject: Re: [MT-L] Magic NPR Help

You don't often get email from...@linuxolutions.com<mailto:lm...@linuxolutions.com>. Learn why this is important<https://aka.ms/LearnAboutSenderIdentification>

** EXTERNAL EMAIL / COURRIEL EXTERNE **
Exercise caution when opening attachments or clicking on links / Faites preuve de prudence si vous ouvrez une pièce jointe ou cliquez sur un lien
Morning Jen:

An alternative to the $ string extraction operator is # which extracts the char at a specific position in a string. Note string extraction operators are zero based so the first character "occupies position zero"! Using # for your exampleVAL=@ee.res.rsrc.grp<mailto:VAL=@ee.res.rsrc.grp>#0

To find the last character you need to determine the length of the string, using the length function L(A) function and convert the length into the zero based position number of the last character, ie length - 1. For your new requirement try VAL=@ee.res.rsrc.grp#(L(<mailto:VAL=@ee.res.rsrc.grp>@ee.res.rsrc.grp)-1)<mailto:VAL=@ee.res.rsrc.grp>

Thanks
Les


On Fri, 2025-08-08 at 13:08 +0000, Fleming, Jennifer via Meditech-L wrote:
Hello,

I have a report where I have a computed field looking at the first letter of a mnemonicVAL=@ee.res.rsrc.grp<mailto:VAL=@ee.res.rsrc.grp>$1<mailto:VAL=@ee.res.rsrc.grp<mailto:VAL=@ee.res.rsrc.grp>$1> and I am now wondering if there is a way to do the same thing but instead look at the last letter in the mnemonic.

Thanks!

Jen


[cid:image0...@01DC084C.650F9910<mailto:image0...@01DC084C.650F9910>]
[iwk-logo]

Jennifer Fleming
Lead, Encounter Management
Information Management & Technology (IM/IT)
Nova Scotia Health Authority
Tel: 902 717-2694
Jennifer...@iwk.nshealth.ca<mailto:Jennifer...@iwk.nshealth.ca><mailto:Jennifer...@iwk.nshealth.ca<mailto:Jennifer...@iwk.nshealth.ca>>



Provincial Service Desk: 902-470-6700
Toll Free: 1-866-224-2555



Confidentiality Notice - If you have received this e-mail in error, or you are not the intended recipient, please do not open any attachments;
Notify the sender by e-mail or telephone that you have received the message, and after notifying the sender, delete the e-mail from your system.

===###===###===###===###===###===###===

To unsubscribe from the meditech-l, follow the instructions at the URLhttp://mtusers.com/mailman/options/meditech-l