Okay, I've finally gotten it to work! Here is the syntax: SUBSTR($Body$, 0, STRSTR($Body$, "STOP HERE"))
Thanks for everyone's help! Carol -----Original Message----- From: Carol Carnevali [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 16, 2007 6:05 PM To: [EMAIL PROTECTED] Cc: Carol Carnevali Subject: Re: How to remove everything after a certain value in a string? Okay, I've gotten the position of the "STOP HERE" (which is a variable) using the STRSTR function and I've set a field with the number. So far so good! But I still can't figure out how to use that number, which is in a field, in the SUBSTR function. Can someone please help me with that part? 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. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"