Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parsing Fields
Message
 
To
05/01/1999 22:26:34
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00173008
Message ID:
00173166
Views:
26
Hi Donald,
What I am guessing you are asking for is how to remove the characters 0-9 from a text field.

There are a number of ways to do this:

You can use the STRTRAN() function

Replace myfield With StrTran(myField,"1","")

of you can loop through the string on character at a time and use the ISDIGIT()
function:

lcString = mytable.myfield
lcOutPut = ""
For x = 1 to Len(lcString)
If Not IsDigit(Substr(lcString,x,1))
lcOutput = lcOutput + Substr(lcString,x,1)
Endif
EndFor

Rodman
Rod Paddock
Editor in Chief CoDe Magazine
President Dash Point Software, Inc.
VP Red Matrix Technologies,Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform