Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data conversion question
Message
 
To
03/11/1998 20:18:02
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00154171
Message ID:
00154174
Views:
22
>I have a character-type field with numbers and dashes in
>it. The dashes are at varying places in each string.
>I want to strip out the dashes (and trim the trailing
>spaces) and then store the resulting stripped
>numeric-only string in another field. How do I do this?

REPLACE somefield with ALLTRIM(STRTRAN(sourcefield, "-",""))
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform