Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Adding Records to cursor after Specific Word
Message
De
15/08/2017 12:28:53
 
 
À
15/08/2017 11:58:10
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8.1
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01653315
Message ID:
01653319
Vues:
51
>Respected all.
>
>I have a Text File say abc.Txt which I have taken it in FILETOSTR using FILETOSTR("ABC.TXT").
>
>The contents of the file are like
>
>*p290Y*p1400XMobile Number :*p290Y*p1750X9425816183*p333Y*p1400XBill No. & Date :*p333Y*p1750X360108912 28/06/2017*p376Y*p1400XPayment Due Date :*p376Y*p1750X15/07/2017
>
>I need to create cursor with each record as
>
>*p290Y*p1400XMobile Number :
>*p290Y*p1750X9425816183
>*p333Y*p1400XBill No. & Date :
>*p333Y*p1750X360108912 28/06/2017
>
>Please suggest some method to do this
>
>Regards
lcText='*p290Y*p1400XMobile Number :*p290Y*p1750X9425816183*p333Y*p1400XBill No. & Date :*p333Y*p1750X360108912 28/06/2017*p376Y*p1400XPayment Due Date :*p376Y*p1750X15/07/2017 '
lnX = 1
do while .t.
   if empty(strextract(lcText,'','',lnX,4)) 
      exit
   Endif
   lcResult= strextract(lcText,'','',lnX,4) + strextract(lcText,'','',lnX+1,4)
   ? strtran(left(lcResult,len(lcResult)-1),'','')
   lnX = lnX + 2
Enddo
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform