I have a 15 Digit Case # starting with BYSM
SUBSTR($Subject$, STRSTR($Subject$, "BYSM")) Set a Hidden Field - zTmpParsedSubjectReq Then LEFT($zTmpParsedSubjectReq$, 15) Doug ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Friday, February 22, 2008 3:26 PM To: [email protected] Subject: Re: Find the Request ID in email Subject line You can also just do a search in the subject line for "ISS[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]" ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eli Schilling Sent: Friday, February 22, 2008 2:14 PM To: [email protected] Subject: Re: Find the Request ID in email Subject line ** Mark, I use STRSTRC within the SUBSTRC function: SUBSTRC($Subject:$, STRSTRC($Subject:$, "TT#") + 3, STRSTRC($Subject:$, "TT#") + 11) That will count the number of characters to TT# and add 3 so you start with the number. If you want to include "TT#" just take away the +3 at the end of the first STRSTRC. HTH -Eli ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Brittain, Mark Sent: Friday, February 22, 2008 11:57 AM To: [email protected] Subject: Find the Request ID in email Subject line ** Hi, I have a requirement to place an email (reply) from a customer that has the ticket number anywhere in the email subject line into the ticket. The challenge is the ticket number could be anywhere in the subject line. If the subject line is something like RE: TT#01049480 for NaviSite, Inc. I can use SUBSTRC($Subject:$, 4, 14) which produces TT#01049480 If the ticket number is somewhere else in the subject line like FW: RE: TT#01049480 then I would get the incorrect results and I would not be able to push the email to the ticket. So I need a string that would find TT# and the eight characters that follow, so I can push that value to a separate field.. Thanks Mark Mark Brittain ESM Remedy Developer NaviSite Inc. 315-453-2912 x5418 (office) 315-317-2897 (cell) This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
