Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Refine a search
Message
 
À
26/05/2015 20:06:46
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01620215
Message ID:
01620271
Vues:
43
BRILLIANT !!!!!!
many thanks dragan - works beautifully - it brings tears to my eyes.

k

>>I have a character field that in many records contains misc data that I don't want to touch.
>>however there are records that are marked with * with data in between and closing *
>>What I want to do is delete the * data * portion of the misc field
>>
>>To add to this task I only want to delete it is it contains the word H14
>>so here is a sample
>>
>>misc: this data I don't want to touch *here is what I want to erase H14* however *this I want to remain A15*
>>
>>Is this even possible??
>
>This is fox. It can be done at least three ways.
>
>
c=yourMemoField
>lcChop="~~~"
>I=0
>do while not empty(lcChop)
>   i=i+1
>   lcChop=strextract(c, "*", "*",i,4)
>   if at("H14", lcChop)>0
>      c=strtran(c, lcchop, "")
>   endif
>enddo
>replace yourMemoField with c
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform