Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Function for Finding Word Position(NOT alphabet)
Message
From
19/08/2013 15:46:31
 
 
To
19/08/2013 15:24:37
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01580784
Message ID:
01580786
Views:
54
>Suppose I am having the following three strings
>
>403.879 378.665 MV (Higher Edu. CESS)SH
>
>456.597 337.070 MV (require any Signature)SH
>
>/F0 FF 7.0 SCF SF 403.879 400.524 MV (Service Tax)SH
>
>I need to extract the Values 403.879 & 378.665 from it (See first String).The above values are always before 'MV'
>
>I may use GETWORDNUM() But How will I get the Position of "MV" in Each string. The AT() Function gives me the character Postion of MV and not Word Position, I need the Word Position.
>
>How It will be Done ?


Use something like:
lcString = "403.879 378.665 MV (Higher Edu. CESS)SH"
IF "MV" $ lcString
    lnPosition = GETWORDCOUNT(LEFT(lcString, AT("MV", lcString) + 1))
ELSE
    lnPosition = -1
ENDIF
* If positive, it was found
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform