Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
String manipulation (preferably without RegExp)
Message
 
 
To
07/11/2006 11:10:25
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01167490
Message ID:
01167699
Views:
7
>Are you replacing the characters with a space or a empty string? It should be a space.
>
>Wait...
>
>I was doing it wrong. try this.
>
>
>c="W-4568S5B"
>? VAL(CHRTRAN(c,CHRTRAN(c,"0123456789",SPACE(100)),SPACE(100)))
>
>
>The CHRTRAN with default to a empty string if a coorisponding character in the third argument is not found.

Thanks, Greg. I may use this idea too.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform