If 'Body' = "I approve this request. STOP HERE - xxxxxxxxxxxxxxxxxxxxxxxxxx"
'tmpBody' = SUBSTR($Body$, 0, STRSTR($Body$,"STOP HERE")) I think this will work. The STRSTR($Body$,"Stop Here") should return you the index of the first letter in "Stop Here" (this is of course assuming you can have more than one character for that argument). The SUBSTR Statement will return the values, from the first character (Index of 0), to the index of the character that the STRSTR statement returns. So, for the above, STRSTR will return 25, the index of the 'S' in STOP HERE. If it will not let you use the full phrase, have them use a special character or something. The SUBSTR will then be SUBSTR($Body$, 0, 25) and will return the first 25 characters of the $Body$ field. You might need to do SUBSTR($Body$,0,(STRSTR($Body$,"STOP HERE") - 1) so you don't grab the 'S' in Stop as well. Again, you might have to have them use like an @ sign or something if the function won't accept the full phrase of "STOP HERE". You could also store STOP HERE in a different field, so users can choose their stop. HTH ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Chris Moore Sent: Wednesday, May 16, 2007 3:46 PM To: [email protected] Subject: Re: How to remove everything after a certain value in a string? ** Carol, I had a similar question the other day- I wanted to strip the last 4 characters off a string in the field 'Search Criteria'. This did it: LEFT($Search Criteria$, LENGTH($Search Criteria$) - 4) So if you know how large your string should be, that can help. I don't know if you can take off anything after a specific string (STOP HERE), but seems like you'd be able to. Sorry I can't help more. Chris On 5/16/07, Carnevali, Carol x23849 <[EMAIL PROTECTED]> wrote: ** 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___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
