Print

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

[rpalmer68]

For my classical collection I have the "composer" field populated in the format Last Name, First Name (eg "Beethoven, Ludwig von").

I also have a user field "Classical Work Name" which is such things as "Symphony No. 1 in C"

In one of my view schemes I would like to have a column "Composer - Classical Work" but want just the last name of the composer not the full field.

Is there a way with the DB expressions to return the left most part of the Composer field up to the ","?

Thanks
Richard

[rpalmer68]

So does a lack of response mean it's not possible?

Cheers
R

[hit_ny]

Not at this moment, the DB expression mid would be ideal for this sort of thing but it needs to be beefed up a bit. Maybe in 11.1

For instance you could then tell it to only display what comes after a separator/character like space or a , even.