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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
