Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to parse numbers only from a string?
Message
From
03/12/2002 17:00:30
Henry Ravichander
RC Management Systems Inc.
Saskatchewan, Canada
 
 
To
03/12/2002 06:00:26
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00728861
Message ID:
00729170
Views:
14
>Problem is that the phone number has been declared as numeric and padL might not work.
>
>Really? Why? Exactly how many mathemetical computations do you do with telephone numbers < s > ?
>
Yea - beats me Marcia - lol.

>Having said that, PADL() will still work with numeric data, but it has the effect of transforming it into character data.
>
I noticed, but that latter is informative in that it is transformed into a character data. Thanks.

>Also, just an FYI, you can use the STRFILTER function in FoxTools to accomplish the same thing that Nadja an Gerald have showed you with CHRTRAN:
>
>SET LIBRARY TO FOXTOOLS ADDITIVE
>lcNewString = STRFILTER( lcOldString, '0123456789' )

Like Dragan says - must have at least 3 ways to skin a fox. Thank you for those quick lessons:)
- Ravi

True greatness consists in being great in little things.
- Charles Simmons
Previous
Reply
Map
View

Click here to load this message in the networking platform