Print

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

[sKiZo]

Pretty much says it all ... MC pulls a whole lot of movie actors I don't need to see in the views and I'd like to limit what shows to the first two or three. It CAN be done in an expression column. Someone here was nice enough to provide the code some time back, but my computer crashed and I can't find the original post or retrieve the code. Seems to me it was something simple, but a review of the wiki made my head hurt.

If I need to see the entire list of actors (hey, it could happen!), they're still available in the tag list and popups.

We need a sticky with helpful expressions that us monkeys who find the editor intimidating can steal ...  

[marko]

Morning...

This will give you the first five actors from the 'Actors' filed....

Code: [Select]

listbuild(1,;,listitem([actors],0),listitem([actors],1),listitem([actors],2),listitem([actors],3),listitem([actors],4))&datatype=[list]
MC has a "Notes" feature. If you use that to store snippets, they get included in your library backups. You should always have a library backup somewhere other than your main computer, just in case. My library is eleven years old, contains around 40,000 files, and the library backup is 12.5 Mb. Stick one on a USB key drive for dire emergencies.

-marko

[MrC]

This is will give you an arbitrary limit.  This limits to 6 actors:

   Regex([actors], /#^((?:[^;]+(?:$|;\s*)){1,6})#/, 1)

Just change the 6 to whatever number you want.

[sKiZo]

Couple ways to skin the cat, eh?

I went with the listbuild expression for two actors ...

The results ... Looks about what I had.  



One little fiddlybit ... how can I add a space between the first actor and the hyphen? Just adding a space in the code gets ignored. Commas don't work either as I expect that's a reserved character in the language. Some special character perhaps?

PS ... the Regex works too, but I already had the other one modified ... be interesting to see how that could be modified to skip the ";" after the last item in the list.

[MrC]

To add a space or comma, escape them with a forward slash, like:

     /,

[sKiZo]

Perfecto!



Thanks, all!