Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Extracting a Portion of a String
Message
From
21/12/2007 19:52:21
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
21/12/2007 19:46:03
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01277122
Message ID:
01277123
Views:
22
>I need to extract the 21 and 22 from this string to get "2122"
>
>
>23^^C4~21^^C4~22^^C4
>
>
>Or it could look like this:
>
>
>23^^C4~22^^C4
>
>
>And I would only want "22"

For these two,

lcChop=strextract(lcString, "~", "^^", i)

(i =1,2, 3,...)

>Or this:
>
>
>23^^C4~21^^C4~22^^C4~27^^C4
>
>
>In which case I want "212227"
>
>The only truly consistent thing is that there will always be a tilde before the numbers I want.

If the ending delimiter isn't sure to be a ^^, you can go like this:
lcDig=""
for i=1 to getwordcount(lcS, "~")
   lcWord=getwordnum(lcS, i, "~")
   j=1
   do while isdig(substr(lcWord,j))
      lcdig=lcdig+substr(lcWord,j,1))
   enddo
endfor
outer loop counts words split at tilde, inner pulls starting digits from these words until a non-digit is encountered..

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