INTERACT FORUM

Please login or register.

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

Author Topic: Expression help needed: cloning a library field to create list  (Read 1110 times)

drmimosa

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 690

Hello,

I'd like to make a new Library Field called Instrumentation for Classical Music in order to use semi-colon deliniated lists to separate instruments. I already have lots of tags in the "Instrument" tag like "Piano and Orchestra" that I'd like to change to a list in the following format "Piano;Orchestra"

Anybody have any suggestions on how to do this?

I've tried to create a calculated data field that copies Instrument to get the tags started, but the copied data disappears when I change the field from calculated data to user data.

Thanks!
Logged

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Re: Expression help needed: cloning a library field to create list
« Reply #1 on: April 11, 2013, 11:50:33 am »

You'll want to use a one-shot expression to assign the values from Instrument to Instrumentation (which will be a list field).  Select your files, edit the Instrumentation field, and enter the expression:

=replace([Instrument], / and/ , ;)
Logged
The opinions I express represent my own folly.

drmimosa

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 690
Re: Expression help needed: cloning a library field to create list
« Reply #2 on: April 11, 2013, 12:53:37 pm »

MrC,

This worked like a charm. I'm now imagining how much time I could have saved using the replace function in other tagging work.

Thanks for your help.

-Phil
Logged
Pages: [1]   Go Up