Thanks Doug. I forget to do the [a-zA-Z] because our SQL Server is case-insensitive. Sometimes a blessing but no always. A nice stored procedure called from a filter would be safest as you would take into consideration your underlying DB. Then there's the maintenance of such workarounds.
Or just be mean and use Pattern Match from the Field Properties. $DIGIT$ only please. --- 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:[email protected]] On Behalf Of Mueller, Doug Sent: Thursday, September 16, 2010 1:18 PM To: [email protected] Subject: EXTERNAL: 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:[email protected]] On Behalf Of Reiser, John J Sent: Thursday, September 16, 2010 10:10 AM To: [email protected] 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:[email protected]] On Behalf Of Bao, Hui-Qing Sent: Thursday, September 16, 2010 12:50 PM To: [email protected] 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"_ _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"
