I'm currently using the code below to search field ABC for one of several text strings; if any of them appear, I set NEW_FIELD to a common result. Is there a better way to do this? In plain english, I'm looking for a statement that says, if ABC contains any of the following: 'STRING1', . . . 'STRING6' then NEW_FIELD = 'RESULT1'
IF INDEX(ABC, 'STRING1') > 0 THEN NEW_FIELD = 'RESULT1';
ELSE IF INDEX(ABC, 'STRING2') > 0 THEN NEW_FIELD = 'RESULT1';
ELSE IF INDEX(ABC, 'STRING3') > 0 THEN NEW_FIELD = 'RESULT1';
ELSE IF INDEX(ABC, 'STRING4') > 0 THEN NEW_FIELD = 'RESULT1';
ELSE IF INDEX(ABC, 'STRING5') > 0 THEN NEW_FIELD = 'RESULT1';
ELSE IF INDEX(ABC, 'STRING6') > 0 THEN NEW_FIELD = 'RESULT1';
... View more