Oh, come on Misi, let's not make this too easy now! We want to keep the pool of developers small :)
Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Misi Mladoniczky Sent: Friday, September 17, 2010 2:11 AM To: [email protected] Subject: Re: 'ISNUMBER' function? Oops, Forgot the wildcard characters in the LIKE statement: It should read like this and nothing else: Run If: 'SerialNumber' LIKE "%[^0-9]%" Action: Message Error Best Regards - Misi, RRR AB, http://rrr.se > Hi, > > Are we not complicating things here? Why not use this simple strategy? > > Run If: 'SerialNumber' LIKE "[^0-9]" > Action: Message Error > > This will match non-digit characters, and I have used it since version 2.0 > :-) > > Best Regards - Misi, RRR AB, http://www.rrr.se > > Products from RRR Scandinavia: > * RRR|License - Not enough Remedy licenses? Save money by optimizing. > * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. > Find these products, and many free tools and utilities, at http://rrr.se. > >> The hard way: (This might be a solution if you have non-English >> characters in there) >> >> Filter 0: >> Run-if: 'SerialNumber' != $NULL$ >> If-Action: Set fields: tmpInt = 0, tmpIsInt = 0, and tmpChar = $NULL$ >> If-Action: Call filter guide >> >> Set a guide label named 'Start' at the beginning of the guide. >> >> Filter 1: >> Run-if: 'SerialNumber' != $NULL$ AND 'tmpIsInt' = 0 >> If-Action: Set Fields: tmpChar = SUBSTR($SerialNumber$, $tmpInt$, >> $tmpInt$ + 1) >> >> Filter 2: >> Run-if: NOT('tmpChar' LIKE "%[0-9]%") >> If-Action: Set Fields: tmpIsInt = 1 >> If-Action: EXIT GUIDE or do a REPLACE($SerialNumber$, $tmpChar$, "") >> to get rid of the non-digit. >> Else-Action: tmpInt = tmpInt + 1 >> >> Filter 3: >> Run-if: tmpIsInt = 0 AND tmpInt < LENGTH($SerialNumber$) + 1 >> If-Action: GO TO GUIDE LABEL => Start >> Else-Action: Set Fields tmpInt = 0 and tmpChar = $NULL$ >> Else-Action: EXIT GUIDE >> >> Filter 4: This is outside of the guide >> Run-if: tmpIsInt = 1 >> If-Action: Set Fields: tmpIsInt = 0 >> If-Action: ERROR PLEASE ENTER ONLY INTEGERS or take whatever action >> you want >> >> >> I didn't test this out, so it might have a few adjustments that needs to >> be made, but basically it will iterate through each character in the >> SerialNumber field, checking to see if it is an integer. If it is not an >> integer, it sets a flag (sets tmpIsInt = 1) and then exits the guide. >> >> Then you can see if tmpIsInt = 1 and perform action on it. It also exits >> the guide once it reaches the last character of the SerialNumber field. >> This is determined by the "tmpInt < LENGTH($SerialNumber$) + 1" in the >> Run-if for Filter 3. You might have to change it to "tmpInt <= >> LENGTH($SerialNumber$) + 1" to accomidate the difference between >> zero-indexed and non-zero indexed functions, I would have to test this. >> >> Also, Filter 3, the LENGTH($SerialNumber$) will be modified if you >> replace a non-digit character with "". In this event, You would likely >> need to perform setting tmpInt = tmpInt - 1 on filter 2 if you choose to >> REPLACE($SerialNumber$, $tmpChar$, ""). >> >> >> >> Thanks, >> >> Gary Opela, Jr. >> Sr. Remedy Engineer >> Avaya Phone Admin >> RSP Cert, Sec+ >> COMM: 405 582 4272 >> >> >> -----Original Message----- >> From: Action Request System discussion list(ARSList) >> [mailto:[email protected]] On Behalf Of >> [email protected] >> Sent: Thursday, September 16, 2010 2:11 PM >> To: [email protected] >> Subject: Re: 'ISNUMBER' function? >> >> ** >> 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 >> >> ________________________________ >> >> From: "Mueller, Doug" <[email protected]> >> Sender: "Action Request System discussion list(ARSList)" >> >> _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" >> >> -- >> This message was scanned by ESVA and is believed to be clean. >> >> > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > > -- > This message was scanned by ESVA and is believed to be clean. > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
