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"

