Thanks Sir.
>>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 ?
lcString = ">/F0 FF 7.0 SCF SF 403.879 400.524 MV (Service Tax)SH"
>st = LEFT(lcString,AT("MV",lcString) - 2)
>x = GETWORDNUM(st,GETWORDCOUNT(st)-1)
>y = GETWORDNUM(st,GETWORDCOUNT(st))
?
Harsh