Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[cron0sRXR8]

I have many videos.
I have many names in the field "actors" for each video.
Always I do copy-paste like this in "actors" field: Rintaro; Akinori Orai; Masayuki Akehi; Jôhei Matsuura; Kazumi Fukushima

So I get this (not alphabetical):
Rintaro
Akinori Orai
Masayuki Akehi
Jôhei Matsuura
Kazumi Fukushima

I want get this (alphabetical ordered):

Akinori Orai
Jôhei Matsuura
Kazumi Fukushima
Masayuki Akehi
Rintaro

Is it possible do it this for all my videos automatically? not one by one.

Thank you!!

[blgentry]

I'm pretty sure an expression can do this.  Something like:

Code: [Select]

=listsort([Actors])
I've tested this by putting that expression into another field and it seemed to work, sorting by actor's first name.  To sort by last name would require more manipulation I think.

The big issue for me is, I can't figure out how to get an expression to assign to a list field!  If I paste that expression into the [Actors] field, it just literally types it and doesn't interpret it as an expression.  I'm not sure if it's possible or not to use expressions on list type fields.

Brian.

[cron0sRXR8]

I'm pretty sure an expression can do this.  Something like:

Code: [Select]

=listsort([Actors])
I've tested this by putting that expression into another field and it seemed to work, sorting by actor's first name.  To sort by last name would require more manipulation I think.

The big issue for me is, I can't figure out how to get an expression to assign to a list field!  If I paste that expression into the [Actors] field, it just literally types it and doesn't interpret it as an expression.  I'm not sure if it's possible or not to use expressions on list type fields.

Brian.

thank you. It's works fine for copy and sort in ANOTHER field. But in the same field, actors, it not work!
but If i delete the actors one by one and apply =listsort([Actors]) IT WORKS!!! I don't know why.

[blgentry]

Ok, I figured out a workaround.

1.  (Select Movie files) > Paste the expression into a temporary field that will hold the sorted Actors values.  I used Comment, since it's empty for all of my movies.  Verify that this worked.
2.  (Select movie files) > Library Tools > Move/Copy fields .  Tell it to copy from Comment to Actors.  Press OK.

That should do it.  Try it with a couple of movies first to verify that it works.  Undo is your friend.

Brian.

[cron0sRXR8]

Ok, I figured out a workaround.

1.  (Select Movie files) > Paste the expression into a temporary field that will hold the sorted Actors values.  I used Comment, since it's empty for all of my movies.  Verify that this worked.
2.  (Select movie files) > Library Tools > Move/Copy fields .  Tell it to copy from Comment to Actors.  Press OK.

That should do it.  Try it with a couple of movies first to verify that it works.  Undo is your friend.

Brian.

I understand you! but I've found a simply system.

1) select many different videos with this actors field problem.
2) apply =listsort([Actors]) in the same ACTORS field and press intro.
3) UN-check ALL actors but NOT this item: =listsort([Actors]) and press intro.
4) now appear the list of actors sort ok! all ok for ALL VIDEOS!! no need one by one. sometimes I can see the field "=listsort([Actors])".
5) un-check "=listsort([Actors])". Now only actors name is there.

finish. Not need copy between 2 fields! 

[blgentry]

Oh, and I just experimented with sorting by last name instead of first name:

Code: [Select]

=unswap(listsort(swap([Actors])))
With Asian names, I recall there being something else about sorting that's complex, but it seems to work for Western names.

Brian.

[blgentry]

3) UN-check ALL actors but NOT this item: =listsort([Actors]) and press intro.

Doesn't that mean you have to uncheck hundreds of actors?  I'd rather copy between fields, as it's way faster.  But hey, if you like your solution, I'm happy for you. 

Brian.

[cron0sRXR8]

Oh, and I just experimented with sorting by last name instead of first name:

Code: [Select]

=unswap(listsort(swap([Actors])))
With Asian names, I recall there being something else about sorting that's complex, but it seems to work for Western names.

Brian.

thank you for the information!! it is valuable

[cron0sRXR8]

Doesn't that mean you have to uncheck hundreds of actors?  I'd rather copy between fields, as it's way faster.  But hey, if you like your solution, I'm happy for you. 

Brian.

It is because I need do it this with many different videos. Not one-by-one video.

[cron0sRXR8]

Doesn't that mean you have to uncheck hundreds of actors?  I'd rather copy between fields, as it's way faster.  But hey, if you like your solution, I'm happy for you. 

Brian.

ops, now I understand. With your system it is possible do it the same more fast!
sorry for my poor english  . you are right!

[cron0sRXR8]

Ok, I figured out a workaround.

2.  (Select movie files) > Library Tools > Move/Copy fields .  Tell it to copy from Comment to Actors.  Press OK.

now it works. thank you.

[blgentry]

Great!  I'm glad you got a solution working. 

Brian.