Sorry for asking, but regexp was always very problematic for me, and from what I have learnt so far regexp is the only way to achieve what I am looking for.
What I basically need is a Filter field expression that finds "the":
Respecting case, so "The", but "the" no
In any field (%_tag%?)
Only as a separate word, so "The" yes, but "There" no
Only inside the word, so no "The" in the beginning, so "Thanks for The memory" yes, but "The Show Must Go On" no
Using an example filter I managed to go as far as title MATCHES (?-i)The, so matching only first condition. I am failing on the following one.
I would also like to take a chance and ask, how to escape certain characters (namely "/") in tags? Because next to finding all "The", I would also like to find all files that has "Funk / Soul" as a genre. Thank you!
Filter can be like this; * HAS “ the “
(Check that the leading and trailing spaces before and after “the” are included)
Note this is not a case sensitive filter, however that can be managed during the replace action below.
Then use the Action (Quick);
Field: _ALL
Original: The
Replace with: the
(Again both the original and replace words need to have the leading and trailing spaces)
Make sure you confirm the case sensitive check box if this is desired.
Note this will apply the action to all fields including filename.
I correct that:
The * would act as an _ALL for the fitler, so the filter could be: * MATCHES " (?-i)The "
The approach using the wildcard for any field leads to a lot of hits - and you have to have a fairly solid confidence that MP3tag does it right.
I would still prefer a more dedicated filter that shows only the hits with matches in a specified field.