INTERACT FORUM

Please login or register.

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

Author Topic: Help splitting combined tag fieldnames  (Read 1965 times)

Chrispy58

  • Recent member
  • *
  • Posts: 30
Help splitting combined tag fieldnames
« on: April 16, 2015, 10:08:10 am »

Hi friends,
I have several Various Artist albums where the [artist] is [various] while the [name] may be [queen - bohemian rhapsody]
can anyone tell me how to split the [name] field and replace various with the artist name please?
TIA
Chris.
Logged

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42053
  • Shoes gone again!
Re: Help splitting combined tag fieldnames
« Reply #1 on: April 16, 2015, 10:32:45 am »

If you edit artist and enter:
=ListItem([Name], 0, - )

I think it would work (if I'm understanding correctly).
Logged
Matt Ashland, JRiver Media Center

CountryBumkin

  • Citizen of the Universe
  • *****
  • Posts: 3352
Re: Help splitting combined tag fieldnames
« Reply #2 on: April 16, 2015, 11:03:02 am »

Or you could do the manual way (if there is a just a couple needing change) and go to Standard View; Audio>Files, scroll to the file(s) you want to change then right click on the field/tag you want to change and select "rename".
Logged

Chrispy58

  • Recent member
  • *
  • Posts: 30
Re: Help splitting combined tag fieldnames
« Reply #3 on: April 28, 2015, 11:40:00 am »

thanks for the response guys - sorry for the delay here, just got back from hols.

I'm afraid there's four albums each having 3 or 4 cd's so doing one at a time manually would take a month of sundays!

Matts solution does look very promising but I nee
Logged

Chrispy58

  • Recent member
  • *
  • Posts: 30
Re: Help splitting combined tag fieldnames
« Reply #4 on: April 28, 2015, 12:03:00 pm »

whoops cont... Matts solution does look very promising, but I need a little further help understanding how to edit the artist.
If I begin by selecting all of the tracks in need of editing (the ones where the artist field says Various on each track)
what next?
TIA Matt
and thanks to CB for the suggestion. 
Logged

Chrispy58

  • Recent member
  • *
  • Posts: 30
Re: Help splitting combined tag fieldnames
« Reply #5 on: May 02, 2015, 02:00:43 pm »

OK Matt, I'm almost there without any further help, BUT....

I edit the artist field in the TAG and enter =ListItem([Name], 0, - ) where it says various

it almost works!!  I get Unchained Melody in the artist field instead of The Righteous Brothers  (the [name] field says unchained melody - the righteous brothers)


I've tried a few slight changes but the correct syntax escapes me ;-)

HELP PLEASE
Logged

Vincent Kars

  • Citizen of the Universe
  • *****
  • Posts: 1154
Re: Help splitting combined tag fieldnames
« Reply #6 on: May 02, 2015, 02:29:34 pm »

[Name] is a bit generic, its context changes with the views you are using.

Use [Artist] instead.
Logged

Chrispy58

  • Recent member
  • *
  • Posts: 30
Re: Help splitting combined tag fieldnames
« Reply #7 on: May 02, 2015, 02:38:54 pm »

Hello= Vin,
the artist field says various
the name field has both artist and title [name - artist]
Logged

Vincent Kars

  • Citizen of the Universe
  • *****
  • Posts: 1154
Re: Help splitting combined tag fieldnames
« Reply #8 on: May 02, 2015, 02:49:50 pm »

=ListItem([Name], 0, - )

This says split Name into elements using " - " as a separator.
0=return first element
1=return second
etc.
If Name contains "queen - bohemian rhapsody" using 0 returns Queen, 1 returns bohemian
http://wiki.jriver.com/index.php?title=Media_Center_expression_language
 
Logged

Chrispy58

  • Recent member
  • *
  • Posts: 30
Re: Help splitting combined tag fieldnames
« Reply #9 on: May 03, 2015, 10:26:46 am »

Many thanks Vin, All sorted now - listitem works a treat.

I did have a bit of trouble with s
Logged

Chrispy58

  • Recent member
  • *
  • Posts: 30
Re: Help splitting combined tag fieldnames
« Reply #10 on: May 03, 2015, 10:37:53 am »

....some tracks misunderstanding the delimiter. The default is ; the delimiter here is 3 characters:- space hyphen space or " - "
I did try, but some tracks had to be done manually :(
Thanks again for the help.
Chris.
Logged

Ferdi

  • World Citizen
  • ***
  • Posts: 195
Re: Help splitting combined tag fieldnames
« Reply #11 on: May 03, 2015, 11:05:16 am »

You could use an external tagging tool, too. MusicBrainz Picard or MP3 Tagger work.
Once you used those tools and saved the changes, update the library inside MC (Update Library from Tags).
Logged

Vincent Kars

  • Citizen of the Universe
  • *****
  • Posts: 1154
Re: Help splitting combined tag fieldnames
« Reply #12 on: May 03, 2015, 01:21:38 pm »

....some tracks misunderstanding the delimiter. The default is ; the delimiter here is 3 characters:- space hyphen space or " - "

One way is to change the delimiter the other one is to use Regex (Regular Expressions).
Regex can cope with all kind of variations but I must admit that although I do understand the concept, in practice I'm suffering most of the time to get it to work.

Best

Vincent
Logged
Pages: [1]   Go Up