INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Need some help with a DB Expression in View Scheme  (Read 807 times)

rpalmer68

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 2639
Need some help with a DB Expression in View Scheme
« 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
Logged

rpalmer68

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 2639
Re: Need some help with a DB Expression in View Scheme
« Reply #1 on: October 27, 2005, 08:27:51 am »

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

Cheers
R
Logged

hit_ny

  • Citizen of the Universe
  • *****
  • Posts: 3310
  • nothing more to say...
Re: Need some help with a DB Expression in View Scheme
« Reply #2 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.
Logged
Pages: [1]   Go Up