INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: First letter of Artist field  (Read 2183 times)

thurston

  • World Citizen
  • ***
  • Posts: 160
First letter of Artist field
« on: October 24, 2008, 12:42:01 pm »

Is there a way to specify the first letter of an audio file's artist tag?  Alternately, is there a way to create a field that contains the letter?

What I'm trying to do is use MC's send to external program feature to open a web page whose address contains this letter. 

Specifically:
In Audio Scheme, right click a song.  Select "Send To", select "Send To (external)", select Add/Edit Programs...
Click Add
Name = Guitar Tab Search
Program Path = iexplore.exe
Parameters = ?

I need a way to express the first letter of the artist in the Parameters such that it reads:
http:////www.ultimate-guitar.com//tabs//[Artist first letter]//[Artist]//[Name].htm

So for the song "Let it Die" by "Foo Fighters", internet explorer would open and go to
http://www.ultimate-guitar.com/tabs/f/foo_fighters/let_it_die_tab.htm

This is another take on the idea posted by mabes for finding guitar music in this thread:
http://yabb.jriver.com/interact/index.php?topic=47080.0

The only part I'm missing is the first letter of the artist.

Thanks



Logged

marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 8941
Re: First letter of Artist field
« Reply #1 on: October 24, 2008, 01:29:29 pm »

mid([artist])

so your link would look like:

http:////www.ultimate-guitar.com//tabs//mid([artist])//[Artist]//[Name].htm

thurston

  • World Citizen
  • ***
  • Posts: 160
Re: First letter of Artist field
« Reply #2 on: November 21, 2008, 11:22:51 am »

Starting to attack this again.  I think the spaces in song titles and artists names instead of an underscore is at fault.  Can I specify that I want to replace spaces with underscores?

Alternately, can I create a new field that copies the song name but substitutes spaces for underscores and then use that in my parameter field?
Logged

marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 8941
Re: First letter of Artist field
« Reply #3 on: November 21, 2008, 12:15:23 pm »

Try:

http:////www.ultimate-guitar.com//tabs//mid([artist])//replace([Artist],/ ,_)//replace([Name],/ ,_).htm

-marko

thurston

  • World Citizen
  • ***
  • Posts: 160
Re: First letter of Artist field
« Reply #4 on: November 21, 2008, 02:49:05 pm »

Thanks Marko!

It works sometimes with Ultimate Guitar, however I have much more success with guitar tab universe at http://www.guitartabs.cc/.

The correct parameter is http:////www.guitartabs.cc//tabs//mid([artist])//replace([Artist],/ ,_)//replace([Name],/ ,_)_tab.html

Thanks so much this is going to make learning songs so much less painful!  I'm going to post full details back in the original thread here:
http://yabb.jriver.com/interact/index.php?topic=47080.0


One final question.  Is there a way to send to external program from TheaterView?
Logged
Pages: [1]   Go Up