Claire, If I understand you correctly, something like this should work.
SUBSTR($email_field$, 0, STRSTR($email_field$, "----")) HTH, Brian From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sanford, Claire Sent: Thursday, May 15, 2008 11:45 AM To: arslist@ARSLIST.ORG Subject: Trimming a field ** I finally got my mail transition form working. As a matter of fact it works too well! I need to delete everything from the "-----Original Message-----" or the "From: Remedy" forward. Any suggestions? Below is a sample of the email that people send to the form: I completed the survey again. Thanks, Donna -----Original Message----- From: Remedy Sent: Friday, May 09, 2008 3:53 PM To: Gill, Donna Subject: Information Systems - Customer Satisfaction Survey - Case (HD0000001542697) Your service request for: " Customer states that the xp antivirus program still keeps popping up and needs it removed " has been completed. We would appreciate your feedback regarding the service provided. Please take a few moments to complete the ISD Customer Service Survey at the link below. Your feedback continues to be our most important measure for determining your satisfaction and our success. Please select this link to complete the ISD Customer Service Survey. Support Resource: Scott Mey Support Team: Desktop Solutions Arrival Time: 5/5/2008 11:14:53 AM Thank you, The ISD Team OR Pager #19185 ________________________________ From: Remedy Sent: Wed 5/14/2008 1:30 AM To: Any help would be appreciated! ARS 6.3 Patch 18 HD 6.0 Oracle 10 w/9 libraries Oracle on a remote server Windows 2003 4 gig on app server and 8 gig on DB server Claire Sanford Information Systems Division Memorial Hermann Healthcare System Phone: 713 448 6035 [EMAIL PROTECTED] __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"
