Thanks All for the input. A combination of all your thoughts provided the final resolution.
Joe, you had a good idea that will probably work, but I first tried Tricia's
method and had good enough results to work it out using no new TMP_Fields.
Jittu, I'm on 7.6.04 and originally tried the method you recommended, but it
failed to do the replace. However, when I combined David's idea with
Tricia's idea, I finally got the result I needed.
Here's how the final code solution looks in the expression editor:
REPLACE($InputString$, RIGHT("x
", 1) "^")
Tricia, the left is not needed, and the "$" is not the line-feed character,
the little box is.. But your idea is pure genius! Thanks much.
You guys are the bomb!
Thanks again;
r
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of David Durling
Sent: Thursday, May 30, 2013 7:46 AM
To: [email protected]
Subject: Re: REPLACE() Function for line-feed / carriage-return
**
What Jittu said has worked for me on ARS 7.5. Note that you have to open
the expression editor (the expand button on the value) to do that - you
can't enter the line return or even cut & paste
"
"
directly into the value for the field.
David Durling
University of Georgia
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Jittu Chacko
Sent: Wednesday, December 30, 2009 4:14 AM
To: [email protected]
Subject: Re: REPLACE() Function for line-feed / carriage-return
**
Hi,
if you mean to identify new line(\n) and replace that with another
character we can do that using set field and REPLACE() function
in set field -->
REPLACE($Input String$, "
", "^")
eg input bmc
software
pune
output bmc^software^pune
you can do this through a button or an active link service action calls
filter with service execution option and do set field.
Regards
Jittu Chacko
Tricia Truong said:
**
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
Joe D'Souza said:
**
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
On 5/30/2013 4:27 AM, Ray Palla wrote:
**
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_
_ARSlist: "Where the Answers Are" and have been for 20 years_
_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>>
