Re: Verifying Numeric Input

2008-08-18 Thread David Bovill
How about something like this Rob? function valid_Number theString, allowCurrency > if allowCurrency is not false then > put "[" & "€£\$" & "]?" into currencyList > else > put empty into currencyList > end if > put "^" & currencyList & > "([1-9]{1}[0-9]{0,2}(\,[0-9]

Re: Verifying Numeric Input

2008-08-17 Thread Rob Cozens
Ken, et al: BTW, Rob - just curious, but when would you see allowing multiple "-"s or multiple currency symbols? I wouldn't...which is why I fault keyDown "numeric input editor handlers" that allow the decimal separator, minus sign, or currency symbol regardless of their frequency (or, in th

Re: Verifying Numeric Input

2008-08-17 Thread Ken Ray
> * Thousand separators, if allowed > > * Users whose number formats use "." as a thousands separator and "'" > as the decimal separator. > > * Entry of multiple "."s in one number > > * Negative numbers, if allowed. And if allowed, multiple "-"s or > embedded "-"s. > > * Currency symbol, if a

Verifying Numeric Input

2008-08-17 Thread Rob Cozens
Hi All, Sorry: I deleted the messages from the original thread before I realized I had something to say. None of the solutions posted so far deal with the following issues: * Thousand separators, if allowed * Users whose number formats use "." as a thousands separator and "'" as the decimal