Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Vfp50 - Stripping spaces out of text.
Message
 
To
02/04/1997 15:02:12
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00026447
Message ID:
00026750
Views:
44
>>If it returns .f. you will need to parse your field and get rid of the imbedded characters
>>
>>To parse try something like
>>
>>STORE UPPER(ALLTRIM(FIELD)) TO mTEST
>>STORE SPACE(0) TO mFieldString
>>FOR i=1 TO len(mTEST)
>> *TEST FOR A-Z
>> IF BETWEEN(ASC(SUBSTR(mTEST,i,1)),65,90)
>> STORE mFieldString + SUBSTR(mTEST,i,1) TO mFieldString
>> ENDIF
>>ENDFOR
>>
>>REPL Field WITH mFieldString
>
>thanks for the code... I need to strip out all characters, not just a through z.
>How would I do this?
>thanks again.. rob

the code above strips everything but A - Z. you might need to include the lowercase letters, but this IS what you were looking for...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform