by thefaceman » Thu Dec 01, 2011 3:00 pm
I am a Newbie at understanding Magic Nodes, and I have had some FANTASTIC help from ZvezdanD getting some new types of Magic Nodes created. Below are several that were created for me (so give others credit not me) and some I created myself (and are not perfect, but get the job done)
I hope they help
Magic Nodes searches
Many of these searches were given to me by MM experts. So full credit goes to them. I just modified them for my own special
needs and hope they can be useful for others. They are not perfect, but they get the job done.
NOTE: Go to EDIT > MAGIC NODES SETTINGS > Click NEW button and then cut and paste the text shown in this post between the two
============ sections into the Mask field and Click the ADD button. The new Magic Node search will be listed.
---------Titles with Weird characters
--------- - There are characters that I prefer to change to standard characters and some listings for multiple artists so I
can keep the title 'pure'.
============
<Group|Name:Title WEIRD Chars...|Show tracks:No>\Featuring WEIRD Chars In title|Icon:Top
level\<Title|Unknown:No|Statistic:Count(All)|Ex Right of: feat. |featuring |vs. |w/|w/ |,,| ,|/|duet |feat |n' |' | '|"|~|!
|`|@|#|$|%|^|&|*|=|_|+|?|()| )|( |]|[|}|{|é|ç|á|ä|ö|°|presents >
============
---------
---------Artists with WEIRD characters
--------- - There are characters that I prefer to change to standard characters and some listings for multiple artists so I
can keep the artist field'pure'. Note: It is not the exact same characters as above but close.
============
<Group|Name:Artist WEIRD chars...|Show tracks:No>\Featuring WEIRD characters in artist|Icon:Top
level\<Artist|Unknown:No|Statistic:Count(All)|Ex Right of: feat. |w/|w/ |featuring |vs. |,,| ,|.|/|duet |feat |n' |' |
'|"|~|!|`|@|$|%|^|&|*|=|_|?|)|(|]|[|}|{|é|ç|á|ä|°|ö|+|presents >
============
---------
---------Artists with Swapped Artists with multiple track listings.
--------- - These are artists who have 'duets' but have the first and last artist listed differently for each track.
(Example: Simon And Garfunkel vs. Garfunkel and Simon).
============
Artists with SWAPPED names (Ella & Louis vs. Louis & Ella)|Filter:UpperW(SubStr(<Artist>, InStr(<Artist>, ' And ') + 5) || '
and ' || SubStr(<Artist>, 1, InStr(<Artist>, ' And ') - 1)) IN (SELECT UpperW(Artist) FROM Artists INNER JOIN ArtistsSongs ON
ArtistsSongs.IDArtist = Artists.ID) OR SubStr(<Artist>, InStr(<Artist>, ' & ') + 3) || ' & ' || SubStr(<Artist>, 1, InStr
(<Artist>, ' & ') - 1) IN (SELECT Artist FROM Artists INNER JOIN ArtistsSongs ON ArtistsSongs.IDArtist = Artists.ID)
============
---------
---------Artists with Multiple ANDS in the artist field.
--------- - Often my artists have too many ANDS in the artist field. Also has some punctuation checks like And, in the title
and artist field. (example Earth And Wind And Fire)
============
Artist with Multiple 'And' in the field|Filter:UpperW(<Artist>) GLOB '* AND * AND *' OR <Artist> Like '%And,%' OR <Title>
Like '%And,%'
============
---------
---------Artist or Title that start with A, An or The.
--------- - This search helps find them all. There are other scripts that can fix them, but at least now you can find them
easier.
============
Artist OR Titles Start with A An OR The|Filter:<Title> Like 'A %' OR <Title> Like 'An %' OR <Title> Like 'The %' OR <Artist>
Like 'A %' OR <Artist> Like 'An %' OR <Artist> Like 'The %'\<Artist>\<Title>
============
---------
---------Artist or Title that have multiple BLANK spaces in the title or artist field
--------- - The Reg/Exp can remove them but this helps FIND them first.
---------
============
Multiple 'spaces' WITHIN an ARTIST or TITLE fields|Filter:<Artist> Like '% %' OR <Title> Like '% %'
============
---------
---------Artist with part of Title listed OR Artist in the Title field.
--------- - Sometimes the tracks have the title and artist merged into the same field. And vice versa. Here are searches to
find both different types.
============
Tracks with Title as a part of Artist|Filter:<Multi Artist> Like '%' || <Title> || '%'
============
============
Tracks with Artist as a part of Title|Filter:<Title> Like '%' || <Multi Artist> || '%'
============
---------
---------Titles that ENDS with a specific character.
--------- - I often have a few characters that seem to be tacked onto my titles that are not easy to find otherwise. Two of
those are '-' (dashes) and 'n'' (ing without the g). I prefer not to have the extra single quote mark in my title. And many
of my titles had an extra 2 at the end when I created some duplicates.
This finds those specific characters, but you can just change the character you prefer in the script.
============
Finding Title that 'ENDS' with a specific character|Filter:<Title> Like '%' || '-' OR <Title> Like '%n''' OR <Title> Like
'%-' OR <Title> Like '%2'
============
---------
---------Titles with common misspellings.
--------- - This is just a start for my list since I could not find a 'spell checker' for mm3.
============
<Group|Name:Title MISSPELLS...|Show tracks:No>\Featuring MISSPELLS In title|Icon:Top level\<Title|Unknown:No|Statistic:Count
(All)|Ex Right of: colour|dont| aint|teh |adn >
============
---------
---------Titles with XMAS (or holiday) titles.
--------- - Again not perfect but has a majority of the xmas season type of song titles.
============
<Group|Name:Titles for XMAS...|Show tracks:No>\Featuring XMAS Titles|Icon:Top level\<Title|Unknown:No|Statistic:Count(All)|Ex
Right of: Altar|Angels|Auld|Ave Maria|Bethlehem|Boy Child|Candy Cane|Candycane|Carol Of|Christmas|claus|Cold
Outside|Coventry|Do You Hear|Drummer|Emmanuel|Fideles|Frosty|Gifts|Gloria|Greensleeves|Herald|Holiday|Holy|Jingle|Joy
To|MangerMary, Did You|Merry|Mistletoe|Navidad|Nutcracker|O Come|O Holy|O Little|Peace On|Pretty
Paper|Reindeer|Rudolph|Saint|Santa|Silent Night|Silver Bells|Sleigh|Snow|Time Of The Year|Three Kings|Three Ships|What Child|
Wenceslas>
============
Hope these are useful.
Last edited by
thefaceman on Thu Jan 05, 2012 10:19 am, edited 1 time in total.