C-Command Software Forum

Complex searching and replacing

Can I type in a boolean search for different elements of an EF record? Here is the scenario I am grappling with. I want to find all the records that have Tag T and do not have the text "wronghame@domain.com" and remove Tag T from the returned records. Is that something I could do?



You can select tag T in the source list, select the relevant records, and then press Delete to remove tag T.

To find the relevant records, normally you could just search with the tag selected, however, although the search field supports negation you must enter at least one search term that is not negated. So the obvious technique doesn’t work in this particular case.

Here are some ways that I can see to do what you want:

  1. Make a smart folder like:

All of the following:
[INDENT]Tags contains T
Anywhere does not match “wronghame@domain.com”


Set the action of the smart folder to remove tag T. Then drag the contents of the smart folder onto the smart folder (to apply the action).

  1. This way is more complicated but may illustrate a technique that you find useful elsewhere:
  2. Make sure Match Partial Words is not checked.
  3. Create two new tags, RemoveT and Wrong.
  4. Select tag T in the source list and select all the records; drag them onto tag RemoveT so that they all have both tags.
  5. With tag T still selected, do an Anywhere search for “wronghame@domain.com”; select and drag all the matches onto tag Wrong.
  6. Select tag RemoveT and do a Tags search for Wrong; select all the matches and press Delete.
  7. Select tag T and do a Tags search for RemoveT; select all the matches and press Delete.
  8. Delete the temporary RemoveT and Wrong tags.