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"