String Function

[atuldalvi]

Hi Guys,

I am having a string like
" BRANCH br1 PNO 000016 tollrail STATUS Closed SCHED-START 22/12/04 RESP ".

I want to find whether BRANCH, PNO,STATUS and SCHED-START fields avaliable in a given string. if avail then i want to take values of this field such as br1 for BRANCH, 000016 for PNO etc.

 

[AndrewSmith]

You can use a combination of the LOOKUP and ENTRY functions. Here's one way:

DEFINE VARIABLE cString AS CHARACTER   NO-UNDO.
DEFINE VARIABLE cValue  AS CHARACTER   NO-UNDO.
 
cString = " BRANCH br1 PNO 000016 tollrail STATUS Closed SCHED-START 22/12/04 RESP ".
 
IF LOOKUP("status",cString," ") > 0 THEN
DO:
    IF NUM-ENTRIES(cString," ") >= LOOKUP("status",cString," ") + 1 THEN
        cValue = ENTRY((LOOKUP("status",cString," ") + 1),cString," ").
 
END.
 
MESSAGE cValue
    VIEW-AS ALERT-BOX INFO BUTTONS OK.

 

[atuldalvi]

thanx andrew