INTERACT FORUM

Please login or register.

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

Author Topic: Calculated Fields  (Read 2154 times)

brainsoup

  • Regular Member
  • World Citizen
  • ***
  • Posts: 151
  • Sexy! No No No...
Calculated Fields
« on: January 04, 2006, 03:50:49 pm »

Done a quick search on this and can't find the answer....

i created a field called "Artist Letter" with the calculated field as Mid([Artist],0,1) to give me the first letter of the artist. However when I did this I accidentally typed Mid(Artist],0,1) into the expression box and therefore every file got 'A'
upon correcting my mistake every file still had 'A' and wouldn't update. i had to remove the field and re-create it.

Do you have to "refresh" when changing a calculated field or something? Am i just being a bit dumb and missing something obvious here?  ?
Logged

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42373
  • Shoes gone again!
Re: Calculated Fields
« Reply #1 on: January 04, 2006, 03:58:10 pm »

It's a bug with the latest build.  It'll be fixed in a build or two.
Logged
Matt Ashland, JRiver Media Center

brainsoup

  • Regular Member
  • World Citizen
  • ***
  • Posts: 151
  • Sexy! No No No...
Re: Calculated Fields
« Reply #2 on: January 04, 2006, 04:10:01 pm »

Thanks Matt.... glad to know I was't going mad! ;) (well not too much more mad than usual!)
Logged

NoCodeUK

  • Citizen of the Universe
  • *****
  • Posts: 1820
Re: Calculated Fields
« Reply #3 on: January 04, 2006, 04:40:17 pm »

Thanks for clarifying that one Matt!

Adam
Logged
"It's called No Code because it's full of code. It's misinformation." - Eddie Vedder

Craig

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 612
Re: Calculated Fields
« Reply #4 on: January 05, 2006, 10:37:11 am »

Just in case you're interested, I sweated for hours over my first calculated field and came up with this -

=if(isequal(Mid([Artist], 0,3),The,1),Mid([Artist], 4,1),Mid([Artist], 0,1)

It returns the first letter of the artist unless it begins with 'The' IE The Who, in which case it will return W instead of T

Hey I'm proud of it  :)

Craig

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

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

marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 9139
Re: Calculated Fields
« Reply #5 on: January 05, 2006, 11:24:12 am »

Just in case you're interested, I sweated for hours over my first calculated field and came up with this -

=if(isequal(Mid([Artist], 0,3),The,1),Mid([Artist], 4,1),Mid([Artist], 0,1)

It returns the first letter of the artist unless it begins with 'The' IE The Who, in which case it will return W instead of T

Hey I'm proud of it  :)
the more people playing with expressions the better IMO, well done to you.

you could find it may need just a little tweak though. imagine you had a few Thelonius Monk albums in your library for example. :)
all you need to do with your expression is change one character, and add another, then it will be reliable.

Craig

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 612
Re: Calculated Fields
« Reply #6 on: January 05, 2006, 01:30:47 pm »

the more people playing with expressions the better IMO, well done to you.

you could find it may need just a little tweak though. imagine you had a few Thelonius Monk albums in your library for example. :)
all you need to do with your expression is change one character, and add another, then it will be reliable.



And I thought it handled The The well :-) that sounds like a challenge Marko - I'll be back

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

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

Craig

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 612
Re: Calculated Fields
« Reply #7 on: January 05, 2006, 01:32:36 pm »

Got it - I think

=if(isequal(Mid([Artist], 0,4),The ,1),Mid([Artist], 4,1),Mid([Artist], 0,1)

Craig

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

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

marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 9139
Re: Calculated Fields
« Reply #8 on: January 05, 2006, 01:38:37 pm »

I think so too :D
Pages: [1]   Go Up