Magic node to count number of words in artist name?

baker · Post 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.

ZvezdanD · Post 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>

baker · Post 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?

Bex · Post 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.

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

Ah that works. Thx Bex.

baker · Post 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.

Bex · Post 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...