I tried this and it worked great
REPLACE(REPLACE($EMP_LOGIN$, LEFT("$", 1), ""), RIGHT("$", 1), "")
$ is LineFeed character, I copy and paste and it did not show, but in the
developer tool it show as a little BOX
Hope it helps
Date: Wed, 29 May 2013 17:57:32 -0500
From: [email protected]
Subject: REPLACE() Function for line-feed / carriage-return
To: [email protected]
**
Hey Kids; Is there a way to use the REPLACE() function in a filter to remove
line feeds and/or carriage returns from text? Is there a special character
code? I’ve tried to paste one into the function with double-quotes around it,
but the function doesn’t seem to recognize it. I just want to replace it with
anything like “^”, to further parse the string as a single line. Thanks in
advance;r Ray Palla
Sr. IT/Remedy Consultant Mobile: 512-917-1739
Time Zone: CentralEmail: [email protected]
Professional ProfileINSONA Corporation
1201 Berry Lane
Georgetown, TX78626-3832 USA
Infrastructure Solutions - Network Applications
_ARSlist: "Where the Answers Are" and have been for 20 years_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
<<inline: image001.jpg>>
<<inline: image002.jpg>>
<<inline: image003.gif>>
