Testing a Character field for Numeric Data'

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Testing a Character field for Numeric Data'

Message

31/07/2009 01:22:38

30/07/2009 17:53:52

Information générale

Forum:

Visual FoxPro

Catégorie:

Codage, syntaxe et commandes

Titre:

Versions des environnements

Visual FoxPro:

VFP 9 SP2

OS:

Windows XP SP2

Divers

Thread ID:

01415119

Message ID:

01415600

Vues:

>LEN(CHRTRAN(ALLTRIM(myField),"0123456789.+-","") = 0 ;
>AND OCCURS(".",myField) < 2 ;
>AND AT("-",myField) < 2 ;
>AND AT("+",myField) < 2
>

which wouldn't take care of the order by allowing ".-444+4" as a valid number.

--
Christof