INTERACT FORUM

Please login or register.

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

Author Topic: Calculated Field Help  (Read 1104 times)

Craig

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 612
Calculated Field Help
« on: December 27, 2005, 08:38:01 am »

Is it possible to add a calculated field which contains the initial letter of the artist name?
I want to use it in my directory structure to keep it easier to navigate.

Thanks in advance
Craig
Logged
MC2Slim - Windows Shell and JRiver Media Center Integration for Squeezebox.

http://www.duff-zapp.co.uk

hit_ny

  • Citizen of the Universe
  • *****
  • Posts: 3310
  • nothing more to say...
Re: Calculated Field Help
« Reply #1 on: December 27, 2005, 09:35:35 am »

Since they allow expressions in Calucalted fields with 11.1, you could use the mid expression to give just the first character.

Not on 11.1 yet myself tho.
Logged

Craig

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 612
Re: Calculated Field Help
« Reply #2 on: December 28, 2005, 08:42:45 am »

Thanks for that, I'm still using 11.0 so I'll have a dabble when i've upgraded.

Craig
Logged
MC2Slim - Windows Shell and JRiver Media Center Integration for Squeezebox.

http://www.duff-zapp.co.uk

EpF

  • Citizen of the Universe
  • *****
  • Posts: 649
Re: Calculated Field Help
« Reply #3 on: January 08, 2006, 11:58:28 am »

Is it possible to add a calculated field which contains the initial letter of the artist name?
I want to use it in my directory structure to keep it easier to navigate.
Did you know that under 'Edit View Scheme', you can add the 'Artist' Field twice, and choose to group the field by a size of 1, which automatically gives you the first letter or digit of the artists name in a pane?

Looks like this:


Is that what you are after?
Pages: [1]   Go Up