Print

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

[ozmael]

In recent builds of 11.1, I've noticed a change in the behaviour of calculated fields.

I have a calculated field called [Name (Full)] which has the following formula (note the extra square brackets around 'Mix Name'):

[Name (Base)] [[Mix Name]]

Formerly, when a song didn't have a value in the [Mix Name] field, the calculated field would ignore the extra square brackets around [Mix Name] and return just the value from [Name (Base)].

In recent builds of 11.1, when the [Mix Name] field is blank, I get an extra set of empty square brackets after the song name as in:

Let the Sunshine In []

Is there any way to instruct MC 11.1 to ignore the extra square brackets when the [Mix Name] field is blank?

Regards

[skeeterfood]

Try this:
[Name (Base)]If(IsEmpty([Mix Name]),, [[Mix Name]])
Note: There probably won't be a space between [Name (Base)] and [[Mix Name]], since the documentation claims that spaces after ','s are ignored...  Not sure how to deal with that...

For more details see: DevZone

-John