Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Refine a search
Message
From
27/05/2015 18:43:44
 
 
To
26/05/2015 20:06:46
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01620215
Message ID:
01620271
Views:
42
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
Previous
Reply
Map
View

Click here to load this message in the networking platform