View Single Post
Old 02-04-2013, 03:09 AM   #2
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 11,733
Karma: 6690881
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
You should use the "pattern" match with a regular expression. Although it isn't possible to say what regexp to use without knowing all the possible text structures in the column, the general approach is to use a pattern that matches only "read". Perhaps you could match "read" at the end of the string (read$), or "read" not followed by an i (read[^i]), or use two contains conditions to check read and not reading.
chaley is offline   Reply With Quote