Sounds like a job for LTRIM: LTRIM (char) char Returns the value of (char)
after deleting any blank

spaces and tabs to the left.

 

Change the form so the users a typing their data into a temporary field.
Have a filter fire on submit or modify that runs the field through LTRIM and
pushes it into the field you are using in the web service

 

J.T. Shyman 
Column Technologies 

  

  _____  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger
Sent: Thursday, February 28, 2008 11: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:

*       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 

 

__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