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: 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
Re: No spaces allowed in a character field
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
Re: No spaces allowed in a character field-RESOLVED
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