All messages should be posted in plain text. HTML will be converted to attachments. The meditech-l web site is MTUsers.com ======================================
You can use the Length/Locate function to accomplish this: L(A,B) where A is the expression to be searched and B is the expression you're searching for. If found, it returns the starting position of B in A (keep in mind that the first position in a string is considered the zero'th position), else it returns the length of A. So if PP.PER.ss.number = 012344019, then L(PP.PER.ss.number,401) = 5 John O'Donnell MIS Analyst Cape Cod Healthcare -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Davison, Regina Sent: Wednesday, March 01, 2006 3:43 PM To: [EMAIL PROTECTED] Cc: [email protected] Subject: [MEDITECH-L] NPR Question-Search a specific field for a string ofdata-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 ************************************************************ This email and any files transmitted with it are confidential. And intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please contact the system administrator for Cape Cod Healthcare. [EMAIL PROTECTED] ************************************************************ _______________________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l
