cancel
Showing results for 
Search instead for 
Did you mean: 

removing a row for a specific text used

LorenzoCapoccia
Level 4
Hi, 
currently, thanks to your team, I was able to exclude from collection any rows containing full details, but now, i want to include the following reason 

basically I want to remove any row that contain the S&S ,  this is contained within the column related to
Offering Name

New S&S - Administration Foundation for z/OS S&S


I tried      "[Offering Name] <> 'S&S'"       but doesn't work, as this seems to work when the full name is used..... 
Can you please help?
thank you in advance
3 REPLIES 3

EmersonF
MVP
You can try "[Offering Name] not like '%S&S%'"
Sr Cons at Avanade Brazil

LorenzoCapoccia
Level 4
Thank you so much, it works:)
@EmersonF

EmersonF
MVP
@Lorenzo Capoccia, perfect!
If this helped you, mark it as useful: D
Sr Cons at Avanade Brazil