Print

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

[Moe]

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.



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.

[Lasse_Lus]

to "custom group", create a custom field with an expression with your choise

[rick.ca]

Or use an expression category...

Code: [Select]

If(IsEqual(ABCDEFGHIJKLMNOPQRSTUVWXYZ, Left([Artist], 1), 8), Left([Artist], 1), 0-9 etc.)

[Moe]

Thank you Rick, that worked perfectly.

I wish I could get my head around the expression stuff.

[rick.ca]

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.