Magic node to count number of words in artist name?

Post a reply

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:
BBCode is ON
[img] is ON
[url] is ON
Smilies are ON
Topic review
   

Expand view Topic review: Magic node to count number of words in artist name?

by Bex » Thu Jan 10, 2008 12:42 pm

Code: Select all

Artists with more than 30 characters (including spaces)|SQL Filter:Length(Songs.Artist)>30 and Songs.Artist like 'the %'\<Artist>

Code: Select all

Artists with more than 5 words|SQL Filter:Length(Songs.Artist) - Length(Replace(Songs.Artist, ' ',''))>5 and Songs.Artist like 'the %'\<Artist>
Not tested...

by baker » Thu Jan 10, 2008 12:14 pm

Is it possible to add a filter that would show only artists that begin with the word "The"? Thx.

by baker » Wed Jan 09, 2008 10:38 pm

Ah that works. Thx Bex.

by Bex » Wed Jan 09, 2008 9:01 pm

They only work with MM3. Get ZvezdanD's latest version of the script and you should be fine.

by baker » Wed Jan 09, 2008 8:48 pm

Thx ZvezdanD but it's not working. I get an error stating "Undefined function LENGTH in expression". I tried it with both MN 1.3b and Modified MN in both 2.5598 and 3.01. Any other ideas?

by ZvezdanD » Wed Jan 09, 2008 6:25 pm

Code: Select all

Artists with more than 30 characters (including spaces)|SQL Filter:Length(Songs.Artist) > 30\<Artist>

Code: Select all

Artists with more than 5 words|SQL Filter:Length(Songs.Artist) - Length(Replace(Songs.Artist, ' ','')) > 5\<Artist>

Magic node to count number of words in artist name?

by baker » Wed Jan 09, 2008 2:26 pm

Hello all. I want to remove the word "The" from those artists with long names. Is it possible to create a MN that would show me only artists with x number or more words or characters in their name? Thx.

Top