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___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
