Print

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

[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?