Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[MarkCoutinho]

Is there anyone in this community that knows how to 'program' this query in MediaCenter?

all songs that don't have the title in the lyrics

For instance: if the title is 'What about us' and the lyrics don't contain this 'sentence', than it should be included in the results.

Help would be highly appreciated!

[lepa]

Something like this as a custom rule for view. Or in pane you could make search list category using this as a filter
[=Find([Lyrics],[Name])]=-1

[marko]

"What's Up" by Four Non Blondes should be in there.

There's not many chart hits like that. I think The Beatles had one, I'm not sure. Anyone else? Google is not allowed

[EnglishTiger]

Something like this as a custom rule for view. Or in pane you could make search list category using this as a filter
[=Find([Lyrics],[Name])]=-1

Unfortunately this test can return "False Negatives"
i.e. searching for the Track Name "4 Real" in the lyrics of Avril Lavign's track of that name will not find the Track Name in the lyrics, because the lyrics contains multiple instances of "for real" not "4 real"

[MarkCoutinho]

Something like this as a custom rule for view. Or in pane you could make search list category using this as a filter
[=Find([Lyrics],[Name])]=-1

That's a good start! Thanks!
However: a comma (,) which isn't in the title but is in the lyrics (i.e. I Need You I Want You, versus 'I need you, I want you') should be excluded. Could you please include that variable in the query?

[zybex]

You need a FuzzyFind() which MC doesn't have 

This may work for you:
[=Find(replace([Lyrics],/,,), replace([Name],/,,))]=-1

Or to ignore all puctuation (this will be slow if you have thousands of songs):
[=Find(replace(regex([Lyrics],/(\w+/),-2),;,), replace(regex([Name],/(\w+/),-2),;,))]=-1

edit: missing parenthesis

[MarkCoutinho]

You need a FuzzyFind() which MC doesn't have 

This may work for you:
[=Find(replace([Lyrics],/,,), replace([Name],/,,)]=-1

Or to ignore all puctuation (this will be slow if you have thousands of songs):
[=Find(replace(regex([Lyrics],/(\w+/),-2),;,), replace(regex([Name],/(\w+/),-2),;,))]=-1

That's a pretty good one! The first one didn't work (probably a typo by you), but the second one does.

I've got some Dutch lyrics issues that aren't solved with this. And I don't want to keep on asking to add a line or variable to the query, so here's my question:

i.e.: Title is "Dit is mijn fiets" and Lyrics says "Dit is m'n fiets"

How do I add a line so that in this case "mijn" is replaced by "m'n" ?
In this case: the title and the lyrics are the same - it's just the way it's pronounced that's different.

(other examples are "zijn" versus "z'n"; "het" versus "'t" etc.)

Thanks again!

[zybex]

That's a pretty good one! The first one didn't work (probably a typo by you), but the second one does.

Missing parenthesis is now fixed.

How do I add a line so that in this case "mijn" is replaced by "m'n" ?
In this case: the title and the lyrics are the same - it's just the way it's pronounced that's different.

(other examples are "zijn" versus "z'n"; "het" versus "'t" etc.)

There are way too many variants like that, you would need that FuzzyMatch() function (which MC does not have) to compute a match percentage instead of simply searching for a string. Google "Levenshtein distance", it's not something that can be done in a simple expression.

That said... you can do an exhaustive search/replace, just keep adding nested "replace" calls to the first 2 lines below. Put it in a computed field/column for more readability:

save(replace(replace(replace(replace([Lyrics],mijn,m'n),zijn,z'n),het,t),4,for), _lyrics)/
save(replace(replace(replace(replace([Name],mijn,m'n),zijn,z'n),het,t),4,for), _name)/
if(isEqual(Find(replace(regex([_Lyrics],/(\w+/),-2),;,), replace(regex([_Name],/(\w+/),-2),;,)),-1),Lyrics mismatch!,)

[MarkCoutinho]

Thanks a lot! I'll give it a go and see how far I get.