JT & Rick, Thanks for the quick response. I found as written the string removed the last character (mbrittai). Once I removed the -1 from the string it worked great! Mark
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman Sent: Thursday, February 28, 2008 4:34 PM To: [email protected] Subject: Re: Strip username from email address ** LEFT($FIELD$,(STRSTR($FIELD$,"@")-1)) --- J.T. Shyman ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Brittain, Mark Sent: Thursday, February 28, 2008 4:27 PM To: [email protected] Subject: Strip username from email address Hi Everyone, When customer replies to an email containing the Ticket Number (RequestID) in the subject line, the email gets pushed from AR System Email Messages to a CSC: Email form, gets massaged and pushed to the ticket. If you want to know why, email me at [EMAIL PROTECTED] and I will be happy to explain the whole project. During the push to the CSC: Email and Ticket forms, the submitter/ last modified by is "Remedy Application Service". What I would like to do is grab the customers email name and use it instead. Something like [EMAIL PROTECTED] to mbrittain. Does anyone have a string that will extract that variable? 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___ 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. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
