Quick question: I know in a saved search filter of a text field I can use wild cards. For example, if i type %x% in a field's filter, the search will return rows for where that field has an 'x' in it. Is there a NOT operator that will work that would return all rows that do NOT have an 'x' in it. I've tried '^' and '!' so far.

have you tried != ?

I’d do a formula numeric with something like

CASE WHEN {fieldname} NOT LIKE '%x%' THEN 1 ELSE 0 END

also, if you tick use expressions there is a "not" column you could tick

@Tristan Day @jen thanks for you responses! I'm trying to do this in a filter that the user can type into, not on the criteria page. See the image below. I think i just have to create 2 separate searches - one with x and one without.

Oh I see. I’m not sure that’s possible (to do a “negative” type-in filter)

@jen unfortunately, i think you're right. But if there is a way, some guru here will know!

I would add a criteria formula text field {…soreference} does not contain X. Add formula text field to Available filters. When the user first runs it, it will default to Not X. Then user can change it to Not Y etc.