Print

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

[MarkCoutinho]

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.

[Scolex]

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.

[Vincent Kars]

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.

[vagskal]

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).

Code: [Select]

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.

[MrC]

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

[MarkCoutinho]

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!

[MarkCoutinho]

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.

[Scolex]

This works for me
http:////www.youtube.com//results?search_query=Hexify("[Artist]") "regex([Name], /#^(.+?)(?: [[(]extended\b[^)\]]*[)\]])?$#/, 1)"&btn=&type=all

[MarkCoutinho]

Almost! It does work, however not with a title of more than 1 word. Could you adjust it a tiny bit, please?

[MrC]

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

[Scolex]

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"

[Scolex]

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

[MrC]

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.

[Scolex]

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.

[MarkCoutinho]

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!