That appears to be helping. I'm still seeing one particular request
with one particular field that this is not working for; I manually took
out all line breaks on that one. The rest of them are working though.
Thanks!!
John
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Friday, January 26, 2007 1:04 PM
To: [email protected]
Subject: Re: REPLACE function not replacing...
**
The problem could be that the line break is sometimes stored as
a line break + space
Try the following
'NewField' = REPLACE($FieldwLineBreak$, LTRIM(RTRIM("
")), " ")
That should remove any space on either side and just replace the
line break
Fred
_____
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of John Hanson
Sent: Friday, January 26, 2007 2:56 PM
To: [email protected]
Subject: REPLACE function not replacing...
**
Hello all,
We've upgraded to:
ARS 6.3 patch 18
Solaris 9
Oracle 10
We've got a problem with some workflow that uses the REPLACE
function; it is supposed to replace line breaks with a space. It works
some of the time, but not other times. The workflow looks like this:
Set Fields
'NewField' = REPLACE($FieldwLineBreak$, "
", " ")
This is set up in both an escalation and a filter and is failing
for both, but only for some of the requests, not for all of them. I
have been able to fix some of the requests by opening $FieldwLineBreak$
and manually deleting the line break and adding it back in, but even
that has only been partially effective. This was working without issue
when we were on 5.1.2. I've tried deleting and rebuilding the workflow
to no effect.
When we upgraded to 6.3, we did not enable Unicode support; I'm
not sure if that's related though. I'm planning on reinstalling and
enabling Unicode support since we need to upgrade to Patch 20 anyway for
the DST fix, but any additional suggestions are greatly appreciated.
Much obliged,
John Hanson
Remedy Administrator/Developer
The Standard
1100 SW Sixth Avenue
Portland, OR 97204
Telephone (971) 321-7153
[EMAIL PROTECTED]
__20060125_______________________This posting was submitted with
HTML in it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
