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"
