I have around 1000 Records in a file. The file has a field PS, In certain records I have a text 'T M' in the middle and the last three words are 'g n'.
Using the following function I am able to locate the PS having 'T M' and 'g n' at the last three digits. But the problem is my below mentioned code locates the first instance of T M and g n , while I need the record number of the last occourance of T M and g n.
I.e I mean to say that I need the last record number whic has the above text.
Is there any way that locate function finds from bottom to top or any other way
Here is my code
LOCATE FOR AT('T M',PS)>0 AND RIGHT(ALLTRIM(Ps),3)='g n'
IF FOUND
lrecordno=RECNO()
ENDIF
Harsh