More > Media Center 14 (Development Ended)

Using FormatRange to group records in a view

(1/1)

MusicHawk:
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?

Navigation

[0] Message Index