Are you sure it is a space? A value of 10 makes me think that it is a
Line Feed character "chr(10)" (as does the fact that the field in Remedy
appears to be blank). I think the user copied or put in a return at the
beginning of the string.
You can do a Set Fields action to remove them.
REPLACE( '$field$', LTRIM(RTRIM( '
')), '' )
NOTE: That is <space><Return><space> inside the trim functions.
That handles the odd situation where Remedy will sometimes add a space
before or after a lone return character.
Fred
________________________________
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger
Sent: Thursday, February 28, 2008 10:50 AM
To: arslist@ARSLIST.ORG
Subject: Capture Space Value
ARS 6.03 patch 16
WIN 2003
SQL2K
We recently discovered an interesting phenomenon. We have a character
field where users enter free text. This text is passed via a web service
to another system. If the user should happen to enter a 'space' as the
first character in the string there are two things that happen:
* On the Remedy side the field appears to be blank. This is the
case even if there is text entered after the 'space'.
* In the other system, the mapped column in the WSDL has a value
of 10.
I need to figure out a way to check the string and see if the first
character is indeed a 'space'. The idea will be to either give the user
an error message or if possible delete the 'space' from the string. If
anyone has a good way to accomplish this I am open to ideas.
Thanks,
Roger A. Nall
Manager, OSSNMS Remedy
T-Mobile, USA
Desk: 813-348-2556
Cell: 973-652-6723
FAX: 813-348-2565
sf49fanv AIM IM
RogerNall Yahoo IM
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
