Select in Field

[#1]

I am having an issue with writing a 'Search String' for a 'Select in Field' action that selects everything NOT equal to a value.  For example if a Field, X, contains the set {A, B, C, D, E}, what would the 'Search String' be if I want to select all values OTHER than 'C'?  I have tried many different combinations.  If the data were numeric it would be simple (<>), but it seems to be more complicated with a string.

Thanks

[marcus_malinow]

Have you tried using Select in Field with 'C', then Select Excluded on the same field?

[#3]

Yes, I have tried and that method doesn't seem to work 100% of the time.  There has to be a way to do this in one step.

[JonnyPoole · Accepted solution]

Here is a technique that worked (after multiple tries )

Build the search string as a variable as follows

below you can see what the variable equals to in the input box on the right

Then invoke 'select in field' action passing the variable as the Search String . It should work.

[#5]

Thanks Jonathan, it works great.