Difference between revisions of "Article Mismatch (Artist)"
From JRiverWiki
Line 15: | Line 15: | ||
This will display all artists with the same name but mismatched 'The ' article. | This will display all artists with the same name but mismatched 'The ' article. | ||
− | [[Category: | + | [[Category:Search Examples]] |
Latest revision as of 00:47, 8 April 2014
If you want to check artists to see whether some entries have 'The ' while others don't:
First, define a user library field:
Tools->Options->Manage Library Fields
Add a 'New Field' called ArtistNoArticles and define it as a calculated field:
if(isequal(mid([artist],0,4),The ,1),mid([artist],4,-1),[artist])
Now use the smartlist:
[Media Type]=[Audio] ~sort=[Artist] ~nodup=[Artist],[ArtistNoArticles] ~dup=[ArtistNoArticles] ~sort=[ArtistNoArticles],[Artist]
This will display all artists with the same name but mismatched 'The ' article.