Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Refine a search
Message
From
26/05/2015 20:06:46
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
26/05/2015 17:31:58
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:
01620220
Views:
72
This message has been marked as the solution to the initial question of the thread.
>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

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform