All messages should be posted in plain text. HTML will be converted to attachments. The meditech-l web site is MTUsers.com ======================================
Use the length function.
IF{L(A,B)’=L(A) "FOUND";"B NOT IN A"}
You can use various permutations of this if statement depending on how you want to use the logic.
L(A) returns the length of A. L(A,B) returns the position that B is found in A and if B is not found in A it will return the length of A. So if the two are not equal that means B was found in A.
----- Original Message ----
From: "Davison, Regina" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Cc: [email protected]
Sent: Wednesday, March 1, 2006 12:43:02 PM
Subject: [MEDITECH-L] NPR Question-Search a specific field for a string of data-Please Post
From: "Davison, Regina" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Cc: [email protected]
Sent: Wednesday, March 1, 2006 12:43:02 PM
Subject: [MEDITECH-L] NPR Question-Search a specific field for a string of data-Please Post
All messages should be posted in plain text. HTML will be converted to
attachments. The meditech-l web site is MTUsers.com
======================================
Is there a quick/easy way to search a data field for a string of characters if you don' t know what position in that field that the string begins in? For instance, if I wanted to search the PP.PER.ss.number field for "401" how is the best way to do that, without knowing what posiiton that the 401 resides in?
Regina Davison
Financial Systems Specialist
Murray-Calloway County Hospital
Phone: 270 762 1273
Fax: 270 762 1332
[EMAIL PROTECTED]
Visit us on the web at <http://www.murrayhospital.org>
NOTICE: This message originates from Murray-Calloway County Hospital (MCCH) and contains information that may be confidential or privileged and is intended only for the individuals or the entity named above. It is prohibited for anyone else to disclose, copy, distribute or use the contents of this message. This message may not be copied or distributed without this disclaimer. All personal messages express views solely of the sender, which are not to be attributed to MCCH. If you received this message in error, please notify us immediately at [EMAIL PROTECTED]
_______________________________________________
meditech-l mailing list
[email protected]
http://mtusers.com/mailman/listinfo/meditech-l
attachments. The meditech-l web site is MTUsers.com
======================================
Is there a quick/easy way to search a data field for a string of characters if you don' t know what position in that field that the string begins in? For instance, if I wanted to search the PP.PER.ss.number field for "401" how is the best way to do that, without knowing what posiiton that the 401 resides in?
Regina Davison
Financial Systems Specialist
Murray-Calloway County Hospital
Phone: 270 762 1273
Fax: 270 762 1332
[EMAIL PROTECTED]
Visit us on the web at <http://www.murrayhospital.org>
NOTICE: This message originates from Murray-Calloway County Hospital (MCCH) and contains information that may be confidential or privileged and is intended only for the individuals or the entity named above. It is prohibited for anyone else to disclose, copy, distribute or use the contents of this message. This message may not be copied or distributed without this disclaimer. All personal messages express views solely of the sender, which are not to be attributed to MCCH. If you received this message in error, please notify us immediately at [EMAIL PROTECTED]
_______________________________________________
meditech-l mailing list
[email protected]
http://mtusers.com/mailman/listinfo/meditech-l
_______________________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l
