'Body' = "I approve this request. STOP HERE - xxxxxxxxxxxxxxxxxxxxxxxxxx" How do I remove everything from STOP HERE on? If you know that the stop here is that came location in the string you can use just the SUBSTR to truncate the rest of the characters. If the stop here may mave you can determine what the position number is by using the STRSTR and then use the location number with the SUBSTR. -----Original Message----- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wed, 16 May 2007 4:34 PM Subject: Re: How to remove everything after a certain value in a string?
** I have looked at those 2 functions but can't figure out how they could work. Could you please provide an example? Thanks. Carol This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. __20060125_______________________This posting was submitted with HTML in it___ ________________________________________________________________________ AOL now offers free email to everyone. Find out more about what's free from AOL at AOL.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"