I had to do something like this a long time ago. I needed to confirm that a value was all numeric. I used the REPLACE function to replace all numeric characters with nothing and if after doing it there was still a value left the string must have at least one alpha or special character in it.
This ought to work regardless of language and use of special characters. Brian Brian Bishop Goldstag Consultants Ltd +44(0)7973 746832 -----Original Message----- From: "Mueller, Doug" <doug_muel...@bmc.com> Sender: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> Date: Thu, 16 Sep 2010 12:18:12 To: <arslist@ARSLIST.ORG> Reply-To: arslist@ARSLIST.ORG Subject: Re: 'ISNUMBER' function? John, Actually, you would need .... LIKE "%[a-zA-Z]%" to allow for upper and lower case letters if you are in a case sensitive database environment (or just to be sure in case insensitive too). AND, this will work only if the serial number uses only ENGLISH characters if there are characters. This is pretty likely for a serial number so this will likely work. It would not necessarily be sufficient in other languages if characters can be present that are not the 26 letters of the English alphabet. Of course, this also assumes that special characters are not allowed because they will have the same issues with converting to numbers as characters. Doug Mueller ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Reiser, John J Sent: Thursday, September 16, 2010 10:10 AM To: arslist@ARSLIST.ORG Subject: Re: 'ISNUMBER' function? ** Use a Run If qualification of 'Serial Number' LIKE "%[a-z]%" The if action sets Int_temp to 0 Else action sets Int_Temp to $Serial Number$ --- John J. Reiser Senior 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 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Bao, Hui-Qing Sent: Thursday, September 16, 2010 12:50 PM To: arslist@ARSLIST.ORG Subject: EXTERNAL: 'ISNUMBER' function? ** All, I wish Remedy provide some kind of function like 'ISNUMBER' I have a character field 'Serial Number', I want to know If the value of this field is a character value or number value. If it is all digit, I need to convert it to integer then apply some workflows based on the data range.. I created an integer field 'Int_temp' and assign 'Serial Number' to this integer field 'Int_temp' = $Serial Number$; Below are the result I got Serial Number Int_temp 67A908675 67 A6789A00006 0 0000067859 67859 If the result is 0, I know the Serial number must be a character value. But for Serial number 67A908675, the result is 67, even the serial number is a character value with the value of 67A908675 . So, is there any easy way to find out if a Character field is number or not? Thanks, Huiqing _____________________________________________________ This electronic message and any files transmitted with it contains information from iDirect, which may be privileged, proprietary and/or confidential. It is intended solely for the use of the individual or entity to whom they are addressed. If you are not the original recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you received this email in error, please delete it and immediately notify the sender. _____________________________________________________ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
