Print

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

[kensn]

In TheraterView:

A Library Field [Artist] grouping of 1 honors the ignore article rule (The Beatles are under the letter B)

An Expression formatrange([artist]) does not honor the ignore article rule (The Beatles are under the letter T)

Is this a shortcoming of using an expression to group by?

Is there a way to have this expression honor the ignore articles rule?

Thanks,
Ken

[kensn]

^

[kensn]

Bumping 1 more time....

[kensn]

I lied.... ^^

[MrC]

I can imagine that the Ignore Articles preference is triggered only when the bare [Artist] field is used in some column, pane, or category, and is not applied generally to all expression output (which would be expensive).

FormatRange() in your expression "sees" the interpolated string value from your Artist field, so inside that function, it has no idea from what field its argument may have originated.  In other words, its just text.

[kensn]

Thanks MrC..

There is not an expression equivalent to [Artist] group by 1 that honors the articles? I have searched and seen different ways to group with regex, but I thought that there could be an expression equivalent to the Grouping (i.e. A-C, D-F, ect.) - Grouping Size (1) function  of the Library field.

Ken

[MrC]

Are you trying to create groupings other than what is provided via the Category > Settings > Grouping setting?  If so, what groupings do you want?

[kensn]

No, not different.. I am setting up views in theater view and just want to have the grouping you get with "library field" but use "expression"  to get "expression to display " that you don't get with "Library field".

Follow?

[MrC]

I see.  What are the range groupings you want?

[kensn]

Just [Artist] grouping by 1, that will honor the articles... Like the default field display...

[MrC]

The only way I know how to do it is by stripping the article from the front.  See if this works for you:

   formatrange(regex([artist], /#^((?:[[:punct:]]|An|Or|The|In|On|Of)\b\s*)?(.+)$#/, 2, 1), 1, 1)

You can add or delete articles in the regex - the format should be pretty obvious.

[kensn]

Appreciate all the help MrC...