Hi,
$DIGIT$ can be used as pattern. I do not know if it allows + or -...
If you create FLTR (ACTL) to control this, you have to specify all
possibilities.
NOT(
'Field1' LIKE "[0-9]" OR
'Field1' LIKE "[-0-9][0-9]" OR
'Field1' LIKE "[-0-9][0-9][0-9]" OR
'Field1' LIKE "[-0-9][0-9][0-9][0-9]" OR
'Field1' LIKE "[-0-9][0-9][0-9][0-9][0-9]"
)
This should allow numbers from -9999 to 99999.
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.
> Hi there,
>
> I have a character field that I need to convert into an integer field
> or to emulate a field that accepts positive and negative numbers only.
>
> This: 'Field1' LIKE "%[^0-9]%" works just fine to enforce numbers
> only.
>
> But how to enforce, that an input consists of numbers only and *can*
> start with a "-" (emulation of negative numbers)?
>
> Thanks,
> Mark
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor:[email protected] 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
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
