Checking for multiple values

[phaworth]

If I want to check for the presence of one of several values in a variable, is it OK to do something like:

if variable contains "ABC" or XYZ" then ....

Pete

[Janschenkel]

Nope, you'll have to spell them out as independent contains comparisons. One options is something like this:

Code: Select all

put "ABC,XYZ" into tContainCriteria
repeat for each item tContainCriterion in tContainCriteria
  if variable contains tContainCriterion then
    -- do your thing
    exit repeat
  end if
end repeat

This approach is dynamic, in that you can easily extend the criteria to whatever length suits you; and the exit repeat ensures that your code is only called once.

HTH,

Jan Schenkel.

[phaworth]

Thanks Jan, I thought that was the case. I had something like what was in my original post and it didn't throw a compilation error but didn't appear to be working.
Pete