Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Determine if char field in a table is a number
Message
From
27/06/2009 11:44:56
Marcia Akins
Arkansas, United States
 
 
To
27/06/2009 11:29:53
James R. Nelson
The Kong Company
Newbury Park, California, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Determine if char field in a table is a number
Miscellaneous
Thread ID:
01408688
Message ID:
01408801
Views:
76
'3.4' isn't a number?
'-3' isn't a number?
IF EMPTY( CHRTRAN( MyTable.MyField, '0123456789.-', '' ) )
  *** This is a number
ENDIF
Of course, this does not take into account the position of the '-' or whether or not there are 2 '.' in the string. But you have received some other advice on how to do this <s>.
Previous
Reply
Map
View

Click here to load this message in the networking platform