Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fast data transfer into Excel avoiding date problems
Message
From
18/07/2003 09:08:46
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00805939
Message ID:
00811461
Views:
24
>>Yes, with chrtran() you can strip out digits and hyphens. If the len() >remains > 0, it means you have a letter, in your example, an "A".
>
>
>>? len(chrtran("7A40-09-7", "0123456789-", "")) > 0
>
>Thanks for all your help, this is working great in production
>
>Jeff

OK, great.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform