I recall this posted by someone about a decade ago and a solution that worked was saving the carriage return to a temp field, and using that temp field in the replace function as the argument.
See if this solution still holds good. Cheers Joe _____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Ray Palla Sent: Wednesday, May 29, 2013 6:58 PM To: [email protected] Subject: REPLACE() Function for line-feed / carriage-return 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 http://www.linkedin.com/img/signature/bg_bluefade_195x42.jpg Mobile: 512-917-1739 Time Zone: Central Email: <mailto:[email protected]> [email protected] http://www.linkedin.com/img/signature/icon_in_blue_14x14.gif Professional Profile <http://www.linkedin.com/pub/1/544/598> <http://www.INSONA.com> INSONA Corporation 1201 Berry Lane <http://maps.google.com/maps?q=10650+SW+Plaza+CT%2CBox%3A+J68%2CHouston%2CTX +77074%2CUSA&hl=en> Georgetown, TX 78626-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"
<<image001.jpg>>
<<image002.jpg>>
<<image003.gif>>
