Well then, Active Link with $FieldID$ LIKE "% %" in the run if. Lose focus to activate it. The If action will be a Message set to Error. The message text will be up to you.
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 10:09 AM To: [email protected] Subject: Re: No spaces allowed in a character field 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: [email protected] > 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: [email protected] > 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"
