Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Changing Text in Records
Message
De
04/12/2017 16:36:10
Walter Meester
HoogkarspelPays-Bas
 
 
À
04/12/2017 16:33:02
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01656116
Message ID:
01656117
Vues:
64
J'aime (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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform