Fred,

 

If I had not tested this myself I would not have believed it. Thanks for
the suggestion.

 

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 

________________________________

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Thursday, February 28, 2008 12:19 PM
To: [email protected]
Subject: Re: Capture Space Value

 

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: [email protected]
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:

1.      On the Remedy side the field appears to be blank. This is the
case even if there is text entered after the 'space'. 
2.      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 

 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Reply via email to