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!