>>Dear Sir please Guide,
>>
>>I have Data as
>>
>>Case-1
>>Ps="F11 B (GENERAL MANAGER \(PROJECT\))31 585 w"
>>
>>Case-2
>>Ps="F11 B (GENERAL MANAGER \(PROJECT\)) 31 585 w"
>>
>>Need to Extrcat value 31 in from the above strings.
>>
>>I am using the following code
>>
>>nColumnposition=VAL(Getwordnum(PS, Getwordcount(PS) - 2))
>>
>>
>>For case 2 i am getting the proper result as there is a space between ) & 31 but for case 1 I am getting the entire string.
>>
>>The value of column may be of three digits also i.e instead of 31 it may be 311 also.
>>
>>What may be the proper solution to the above
>>
>>Regards
>
>What is your criteria to get 31 in both cases? If it is the first "number after last closing parentheses" then:
>
>
>?Ltrim(Str(val(Substr(m.ps,Rat(")",m.ps)+1))))
>
>
>Depending on your criteria and what exactly you want, a regexp based solution might be better.
Thanks sir, its working
Harsh