Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do you extract parts of a string in a field?
Message
 
To
21/12/2000 08:49:13
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00455835
Message ID:
00455859
Views:
21
>Hi All! How do you extract certain parts of a string. Like I want to replace the first three digits of a field with something. ie. 50-1020 with 95-1020
>Anything that begins with 50- I want to replace it with 95-
>
>Thanks in advance for your help!
>
>Joe

Joe: You can use
REPLACE MyField WITH "95-" + SUBS(MyField,4)
or also you can use
REPLACE MyField WITH STRTRAN(MyField, "50-", "95-")
Selects the sentence that but to you agrees
Luis María Guayán
Tucumán, Argentina
________________________________
SysOp de www.PortalFox.com
Nada corre como un zorro
________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform