thefaceman wrote:My newest 'problem' is finding duplicates with the same Artist values but with 'swapped' positions within that field
Ella Fitzgerald And Louis Armstrong vs. Louis Armstron And Ella Fitzgerald.
I am not so concerned if the titles are correct, I can find those later. I just want my artist fields with multiple artists following the same format so I can avoid duplicates in the future.
This may be a Reg/Exp script solution though.
I don't understand what you want. I already gave you the solution for that request. Did you try the mask that I posted in viewtopic.php?p=319261#p319261
? It works with multi-item artists as well.
Of course, Magic Nodes cannot modify tags, its purpose is only to display the groups of tracks. If you want to swap artists written in such format, e.g. Ella Fitzgerald And Louis Armstrong -> Louis Armstrong And Ella Fitzgerald, you could use the RegExp's "Swap text separated by specified string in <Into Field>..." preset with the specified " And " string. However, it could be used only for single-item artists. If you want to do the same thing with multi-item artists, you could use the following settings:
Preset: Swap names separated with " And " or " & " in <Into Field>...
Description: Ella and Louis -> Louis and Ella or Ella & Louis -> Louis & Ella (works with multi-item fields as well)
Find what: (\s*)([^;]+?)(\s+(?:and|&)\s+)([^;]+?)($|;\s*)
Regular expression 1: checked
Replace with: $1$4$3$2$5
Sorry I did see the mask but it did not 'FIND' any artists. I know I have some in my database though.
The Reg/Exp option just seems to find ALL 'And' artists and swaps them around.
I may not be clear on my request.
Here is an more detailed example.
I have an artist with two artists and same title
Ella Fitzgerald and Louis Armstrong - Baby, It's Cold Outside.mp3
Louis Armstrong And Ella Fitzgerald - Baby, It's Cold Outside.mp3
But the issue is not really duplicates it is more about consistency.
I want all my AND artists to have the same 'format' So if there are OTHER songs by either Louis Armstrong And Ella Fitzgerald it will find them as a 'Duplicate'. I do not care if I only have ONE song by them, it is a matter of making ALL of the 'DUET' artists have the SAME artist name ORDER as they are listed. I am willing to have it done alphabetically if that makes it easier.
BUT I am also willing to just FIND them and fix them myself manually so that all DUET artists have the same "LISTING ORDER".
I do not need it for >2 artists like Blood, Sweat And Tears, as those do not happen very often, but it if is EASY to do then it would just be a nice bonus.
I hope this clarifies my situation.
The other 2 problems
2. Finding all of the artists with commonly misspelled or variations on words
Color vs Colour or Don't vs Do Not.
Yes I have started my own 'list' of 'misspellings' but I was hoping someone would have done a 'common' one of typos like
"adn" (and) or "teh" (the). and added common language differences like "color' vs "colour". It does not have to 'change' them just FIND them would be enough.
3. And the n' WORKS nicely. Now I know the ' (single quote) is the 'escape' character I needed to use
Sorry for continued troubleshooting