Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changing Text in Records
Message
From
04/12/2017 16:36:10
Walter Meester
HoogkarspelNetherlands
 
 
To
04/12/2017 16:33:02
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01656116
Message ID:
01656117
Views:
63
Likes (1)
>Hi All,
>
>I have a Cursor with Field Name cText in which there are around 2000 records each of length from 10 to 254.
>In these records there is a word say "xyz' in between these Records. The xyz may be at any position inside the record.
>I need to change all the instances of this word xyz to say ABCD or any thing else, for all the records from top to bottom.
>
>Is there any simple way to it in a single command for all the records , other than scanning the entire File from Top to bottom using Scan-Endscan loop.
>
>I also don't want to use FILETOSTR(), occurs() etc as already I have created a cursor for some purpose and have taken Text in SDF.
>
>Thanks.


REPLACE ALL cText WITH STRTRAN(cText, 'xyz','ABCD') FOR 'xyz' $ cText IN Mycursor
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform