INTERACT FORUM
More => Old Versions => Media Center 16 (Development Ended) => Topic started by: Moe on June 06, 2011, 03:20:47 pm
-
I have a theater view view setup that utilizes grouping. I have a lot of artists so the grouping comes in really handy. There is one little thing that bugs me about the grouping. Here is what my view looks like.
(http://www.moesrealm.com/mc/grouping.jpg)
What I would like is an option to group "Others" (which is artists that start with odd characters like (Hed) P.E or 'Til Tuesday) and the artists that start with a number (311 and 50 Cent for instance) into one group.
So the view would list something like Other,0-9 and then A, B, C etc.
Basically I just want to be able to group bands that start with numbers and symbols together.
-
to "custom group", create a custom field with an expression with your choise
-
Or use an expression category...
If(IsEqual(ABCDEFGHIJKLMNOPQRSTUVWXYZ, Left([Artist], 1), 8), Left([Artist], 1), 0-9 etc.)
-
Thank you Rick, that worked perfectly.
I wish I could get my head around the expression stuff.
-
I wish I could get my head around the expression stuff.
I usually discover something that works by trial and error long before getting my head around why it works. I usually do that by adding an expression column to an applicable view—where I can edit the expression and instantly see the results. For something complex, I'll use separate columns for different "pieces" of the expression, until I'm sure each one works correctly. When I get stuck, I refer to marko's excellent wiki topic (http://wiki.jriver.com/index.php/Media_Center_expression_language).