LOAD Pippo
if(color = 'green', 'ok',
if(color = 'yellow' and text <> 'No control needed', 'check',
if(color = 'red' and text <> 'Control now', 'check', 'ok'))) as Pippo1
In the line with thecolor = yellow, I want to catch different cases because there are many text occurrences starting with'No control needed'(for example No control needed (for 1 week), No control needed (for 2 weeks)), and I want to select them all.
I tried using:text<>'No control needed'*, but it did not work.