All OK I'm halfway home. The expand box adding the carriage return works. So how do you delete a line that only has a carriage return it it ? I did't really want to insert the " " but the function wouldn't let me set it to NULL.
Kevin -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Monday, January 07, 2008 1:54 PM To: arslist@ARSLIST.ORG Subject: Re: Help on Replace Function Kevin, whenever you are setting your value to REPLACE(), hit the expand box to the right of the field, then hit an enter. Fore example, you would have: REPLACE($FIELD$, "Bob is here. ", " ") Just hit return after your period, and it should work. You will have to use your expand box function to be able to hit return. Whenever you hit Okay on the expand box window that pops up, the new line will show up as a NPC (Non printable character), such as a solid block. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Thornley Sent: Monday, January 07, 2008 3:37 PM To: arslist@ARSLIST.ORG Subject: Help on Replace Function ** All I can't seem to remember how to use a carriage return with the replace function. Basically I need to search for a certain 1 line sentence & remove it. Using the example below it only finds the string and replaces it with a space. I need it to find the string + the carriage return and replace it with nothing. REPLACE ( Some Field, "This is a test"," ") Thanks Kevin __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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
