python syntax for string in list of strings

Question

if 'PASSED' in cell.value or 'FAILED' in cell.value or 'INVALID' in cell.value:
    Test.append(6)

What is a more concise way to do this? I want to make it do something like

if cell.value in ('PASSED','INVALID', 'FAILED')

but that doesn't work

possible duplicate of How to check if one of the following items is in a list? — alexo_o
– alexo_o, Commented Jul 24, 2015 at 18:57
Why does this 'hello' in ( 'hello', 'world' ) #returns True not work for you? Are you sure that cell.value is a string ? — dermen
– dermen, Commented Jul 24, 2015 at 18:58
If cell.value is a string then "if cell.value in ('PASSED','INVALID', 'FAILED'):" will absolutely work - what error did you get? — gkusner
– gkusner, Commented Jul 24, 2015 at 19:03
@dermen: clearly cell.value is a larger string which may contain any of those three strings. — Martijn Pieters
– Martijn Pieters, Commented Jul 24, 2015 at 21:02
@gkusner: that'll only work if cell.value is exactly one of those strings, but not if cell.value contains such a string; e.g. cell.value is a longer string like "The tests results were INVALID". 'INVALID' in cell.value is then true, but your test is not. — Martijn Pieters
– Martijn Pieters, Commented Jul 24, 2015 at 21:04

Martijn Pieters · Accepted Answer · 2015-07-24 21:01:41Z

3

if any(s in cell.value for s in ('PASSED','INVALID', 'FAILED')):

This tests each string in turn, returning True as soon as a test passes.

answered Jul 24, 2015 at 18:53

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1