INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: rpalmer68 on October 26, 2005, 04:27:26 am

Title: Need some help with a DB Expression in View Scheme
Post by: rpalmer68 on October 26, 2005, 04:27:26 am

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

Title: Re: Need some help with a DB Expression in View Scheme
Post by: rpalmer68 on October 27, 2005, 08:27:51 am

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

Cheers
R

Title: Re: Need some help with a DB Expression in View Scheme
Post by: hit_ny on October 27, 2005, 09:49:52 am

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.