So like Claude Debussy you found the silence between the notes.
;^.)>
---
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
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Misi Mladoniczky
Sent: Friday, September 17, 2010 2:48 AM
To: [email protected]
Subject: EXTERNAL: Re: 'ISNUMBER' function?
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"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
