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]
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
