Kevin, Click the Expand Box, and in expanded mode type:
REPLACE( Some Field, "", " ") Then put your cursor between the first two quotes and press <Enter>. This will make it look like this: REPLACE ( Some Field, " "," ") In unexpanded mode it will look like this: REPLACE( Some Field, "|"," ") When your workflow runs it will replace your carriage return with a space. Dwayne Martin James Madison University ---- Original message ---- >Date: Mon, 7 Jan 2008 13:37:28 -0800 >From: Kevin Thornley <[EMAIL PROTECTED]> >Subject: Help on Replace Function >To: [email protected] > > ** > > 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"
