INTERACT FORUM

More => Old Versions => Media Center 12 (Development Ended) => Topic started by: RobOK on February 04, 2007, 09:36:55 am

Title: multi-field copy and paste
Post by: RobOK 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!

Title: Re: multi-field copy and paste
Post by: RobOK 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.

Title: Re: multi-field copy and paste
Post by: RobOK 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.