INTERACT FORUM
More => Old Versions => Media Center 17 => Topic started by: MarkCoutinho on June 04, 2012, 07:25:18 am
-
I use the links in MC a lot. I've got one for Discogs, for example, that searches for the artist in combination with the title.
However: quite a few songs of mine are extended versions. Therefor the search withing for instance Discogs comes up empty.
Which brings me to the following question:
How can I exclude the string I mention here below from my URL?
Right now it's like this: http:////www.discogs.com//search?q=[Artist]+[Name]&btn=&type=all
The string that has to be excluded is:
(Extended version)
Thanks for your help.
-
Your best bet would be to use a custom field that is calculated from [Name] instead of [Name] and
create an expression that will omit the () and whatever is inside them from the data.
My knowledge is pretty limited when it comes to expressions but I would think there is a way to do it.
Sorry I couldn't be more helpful but hopefully it will point you in the correct direction.
Maybe someone else will chime in on how to do the expression if possible.
-
A caluclate field NameC
[artist] - replace([name],/(extendended..../))
(havent tried it)
http://wiki.jriver.com/index.php/Media_Center_expression_language#Replace.28....29:_Replace_or_remove_strings_from_a_value.
-
I use this in a calculated field to clean out everything in a song name that ends with (...) or [...]. It works for me (but it is not very nice coding now that we have other possibilities).
if(isequal(left([name],1),/(,1),[name],if(isequal(left([name],1),[,1),[name],if(isequal(listcount([name],/(),1,5),clean(ListItem([name],0,/()),if(isequal(listcount([name],[),1,5),clean(ListItem([name],0,[)),[name]))))
MrC suggested some improvements in a hidden thread (replace [Album] with [Name]):
Two variations of your adjust expression:
ifelse(
regex([album], /#^[([]#/), [album],
regex([album], /#^(.*?)[([]#/), clean([R1]),
1, [album]
)
ifelse(
regex([album], /#^[([]#/), [album],
Compare(listcount([album], /(), >, 1), clean(ListItem([album], 0, /()),
Compare(listcount([album], [), >, 1), clean(ListItem([album], 0, [)),
1, [album]
)
I have not tried the suggestions out yet (sorry, MrC).
You could see if any of those will work for you when used in searches.
-
Here's a quick way to handle it:
http:////www.discogs.com//search?q=[Artist]+regex([Name], /#^(.+?)(?: [[(]extended\b[^)\]]*[)\]])?$#/, 1)&btn=&type=all
This case-insensitively removes the following forms at the end of Name, within either () or [] brackets (or mixed):
extended
extended blah
extended blah blah blah
-
Superduper! Thanks to you all for your kind responses.
MrC's is spot on - I use that one now. But I've learned something too from the other examples.
Great, guys!
-
I've changed all my links with help of this, but the YouTube-link won't work because it's a bit different.
I have changed it to this:
http:////www.youtube.com//results?search_query=Hexify("[Artist]" "[Name]", /#^(.+?)(?: [[(]extended\b[^)\]]*[)\]])?$#/, 1)&btn=&type=all)
But then the site comes up with "artist name" "title (extended version)
So: artist name is good (between the " and the ") but the title has got to get rid of (extended version) and the " has to be added at the end of the title.
How should I do that?
Thanks again.
-
This works for me
http:////www.youtube.com//results?search_query=Hexify("[Artist]") "regex([Name], /#^(.+?)(?: [[(]extended\b[^)\]]*[)\]])?$#/, 1)"&btn=&type=all
-
Almost! It does work, however not with a title of more than 1 word. Could you adjust it a tiny bit, please?
-
You can include [Artist] as part of the regex param, and hexify() the result:
http:////www.youtube.com//results?search_query="Hexify(regex([Artist] [Name], /#^(.+?)(?: [[(]extended\b[^)\]]*[)\]])?$#/, 1))"&btn=&type=all
-
Almost! It does work, however not with a title of more than 1 word. Could you adjust it a tiny bit, please?
That is odd because this is what I searched for after setting up a test file earlier
Artist: +44
Name: When Your Heart Stop Beating (Extended Version)
Youtube search showed "+44" "When Your Heart Stop Beating"
Just setup another and it worked fine also
Artist: 3 Doors Down
Name: It's the Only One You've Got (Extended Version)
Youtube search showed "3 Doors Down" "It's the Only One You've Got"
-
You can include [Artist] as part of the regex param, and hexify() the result:
http:////www.youtube.com//results?search_query="Hexify(regex([Artist] [Name], /#^(.+?)(?: [[(]extended\b[^)\]]*[)\]])?$#/, 1))"&btn=&type=all
The reason I did it the way I did is he had quotes around Artist and Name separately and I don't know how to hexify and have the quotes inside the regex.
Maybe you can enlighten me.
I tried the below but when I used it the (Extended Version) was not removed
http:////www.youtube.com//results?search_query=Hexify(regex("[Artist]" "[Name]", /#^(.+?)(?: [[(]extended\b[^)\]]*[)\]])?$#/, 1))"&btn=&type=al
-
Sorry, I gave some junk earlier. I was busy talking in the background, not paying attention.
See if this works:
http:////www.youtube.com//results?search_query=Hexify(regex("[Artist]" "[Name], /#^(.+?)(?: [[(]extended\b[^)\]]*[)\]])?$#/, 1)")&btn=&type=al
This keeps the same RE.
-
Thanks that worked I figured I just needed to move the quotes around but wasn't sure exactly where and my original worked although not very pretty since the Name wasn't being hexified.
-
Yeah! It works for me too! I've got all my links working and I want to share them with those who are interested.
All results involve these parameters:
- artist is between quotes
- name is between quotes
- addition (extended version) is left out of the result
These are my links:
YouTube: http:////www.youtube.com//results?search_query=Hexify(regex("[Artist]" "[Name], /#^(.+?)(?: [[(]extended\b[^)\]]*[)\]])?$#/, 1)")&btn=&type=al
Lyrics: http:////www.google.com//search?q=lyrics Hexify(regex("[Artist]" "[Name], /#^(.+?)(?: [[(]extended\b[^)\]]*[)\]])?$#/, 1)")&btn=&type=al
Discogs: http:////www.discogs.com//search?q=[Artist]+regex([Name], /#^(.+?)(?: [[(]extended\b[^)\]]*[)\]])?$#/, 1)&btn=&type=all
Covers: http:////images.google.com//images?q=Hexify(regex("[Artist]" "[Name], /#^(.+?)(?: [[(]extended\b[^)\]]*[)\]])?$#/, 1)")&btn=&type=al
Thanks to all those who were willing to help me on this one!