Thanks for the response. I used the filter (set field) (since needed to take care of webservice / import mechanism) with substr function .
Atul > ----- Original Message ----- > From: "Ben Chernys" <[EMAIL PROTECTED]> > To: arslist@ARSLIST.ORG > Subject: Re: No spaces allowed in a character field > Date: Tue, 22 Jul 2008 16:21:45 +0200 > > > So why don't you just use John's suggestion in a Set Fields to another > Display > only field, then make a new AL with a higher sequence number that has as a > qualification 'a' != 'b' and produce an error in that case. > > If the replace did nothing you will not get an error. (The AL will not fire > as the two fields will be equal.) > > Cheers > Ben > > > ----- ------- Original Message ------- ----- > > From: Atul Vohra > > <[EMAIL PROTECTED]> > > To: arslist@ARSLIST.ORG > > Sent: Tue, 22 Jul 2008 10:09:19 > > > > Thanks for the response - My effort is to "error out" if there is a space - > > not replace it. > > > > Atul > >> ----- Original Message ----- > >> From: "Reiser, John J" <[EMAIL PROTECTED]> > >> To: arslist@ARSLIST.ORG > >> Subject: Re: No spaces allowed in a character > > field > >> Date: Tue, 22 Jul 2008 10:05:04 -0400 > >> > >> > >> Atul, > >> > >> If you need to stop spaces at the left or right > > side of the data string > >> use LTRIM() and RTRIM(). > >> For spaces in the string you will need to use > > REPLACE($FieldID$," ","") > >> You may need to check for additional spaces and > > loop through the string. > >> I think REPLACE() will only affect the first > > instance of the " ". > >> All of these are best done in a filter as a set > > fields action. > >> HTH, > >> > >> John J. Reiser > >> Software Development Analyst > >> Remedy Administrator/Developer > >> Lockheed Martin - MS2 > >> The star that burns twice as bright burns half as > > long. > >> Pay close attention and be illuminated by its > > brilliance. - paraphrased > >> by me > >> > >> > >> -----Original Message----- > >> From: Action Request System discussion > > list(ARSList) > >> [mailto:[EMAIL PROTECTED] On Behalf Of Atul > > Vohra > >> Sent: Tuesday, July 22, 2008 9:54 AM > >> To: arslist@ARSLIST.ORG > >> Subject: No spaces allowed in a character field > >> > >> Hi All, > >> > >> This might be very trivial but wanted to get > > opinion from the list for > >> the best possible solution: > >> > >> I have to stop spaces from entered in a character > > field. The data can be > >> entered using the user tool/ mid-tier and > > webservice/import tool. > >> > >> We are on ARS 6.3, Oracle 10g and Solaris. > >> > >> Thanks > >> Atul > >> > >> > > ___________________________________________________ > > _____________________ > >> _______ > >> UNSUBSCRIBE or access ARSlist Archives at > > www.arslist.org Platinum > >> Sponsor: www.rmsportal.com ARSlist: "Where the > > Answers Are" > >> > >> > > ___________________________________________________ > > ____________________________ > >> UNSUBSCRIBE or access ARSlist Archives at > > www.arslist.org > >> Platinum Sponsor: www.rmsportal.com ARSlist: > > "Where the Answers Are" > > > >> > > > > ___________________________________________________ > > ____________________________ > > UNSUBSCRIBE or access ARSlist Archives at > > www.arslist.org > > Platinum Sponsor: www.rmsportal.com ARSlist: "Where > > the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
