INTERACT FORUM

Please login or register.

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

Author Topic: multi-field copy and paste  (Read 1113 times)

RobOK

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 615
  • long time MC user for PC, iPod and Tivo
multi-field copy and paste
« on: February 04, 2007, 09:36:55 am »

Is it possilbe to copy from multiple fields into one field?

Keywords is empty for me now.  I would like to copy Subject+Album+People+Things into Keywords across my whole library.  Is this possible?

Thanks!
Logged

RobOK

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 615
  • long time MC user for PC, iPod and Tivo
Re: multi-field copy and paste
« Reply #1 on: February 04, 2007, 09:44:33 am »

I tried creating a new Library field of Keyword Calculated and put the formula as

[Subject];[Album];[People];[Things]

but got a lot of fields that looked like:

; Christmas;; Flowers

With all the extra semicolons.   I think if I can get that right, i can then do a copy and paste of fields and then delete the new Library field.  That is my goal.

EDIT....

and when People has multiple selections, they don't become seperate Keywords, they are all one key word.

so it ends up:

Christmas;Rob;Joe;Steve     as ONE keyword, not FOUR.



Logged

RobOK

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 615
  • long time MC user for PC, iPod and Tivo
Re: multi-field copy and paste
« Reply #2 on: February 04, 2007, 10:42:41 am »

Hmmm....  I might have done it.

1.  Keywords -->  new Field 1, calculated in Library field setup as above, comes out with multiple ;;; and is not really mutli-value.  But then,

2.  new Field 1  Copy data to new Field 2 which is editable and multi-value.  The editable field correctly handles the multi value and the extra semi-colons.


I think in step 1, when I made it a calculated field it was automatically a string not a multi-value field.


Logged
Pages: [1]   Go Up