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
Harsh