INTERACT FORUM
More => Old Versions => Media Center 14 (Development Ended) => Topic started by: MusicHawk on May 28, 2010, 03:17:43 pm
-
I believe the below expression used to work for me, but it's been a while (function FormatRange was introduced in MC11).
In a view, first column, I put this expression:
FormatRange([Chart],2,1)
Values for Chart might be AC#12, RB#37, CW#18, etc.
I want the view to group records on the first 2 letters of the Chart value, like this:
AC
CW
RB
If I let MC do built-in grouping, it works but I get this:
A
C
R
...not what I want.
Left([Chart],2) doesn't do anything either.
Suggestions/corrections?