Certain versions of ARS insert a space just before the new-line
character. Try using LTRIM in your REPLACE command.
REPLACE($FieldwLineBreak$, LTRIM(" |"), " ")
Stephen
________________________________
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of John Hanson
Sent: Friday, January 26, 2007 3: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"
