INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: brainsoup on January 04, 2006, 03:50:49 pm

Title: Calculated Fields
Post by: brainsoup 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?  ?

Title: Re: Calculated Fields
Post by: Matt 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.

Title: Re: Calculated Fields
Post by: brainsoup 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!)

Title: Re: Calculated Fields
Post by: NoCodeUK on January 04, 2006, 04:40:17 pm

Thanks for clarifying that one Matt!

Adam

Title: Re: Calculated Fields
Post by: Craig 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

Title: Re: Calculated Fields
Post by: marko on January 05, 2006, 11:24:12 am

Quote from: Craig 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  :)

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.

Title: Re: Calculated Fields
Post by: Craig on January 05, 2006, 01:30:47 pm

Quote from: marko on January 05, 2006, 11:24:12 am

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

Title: Re: Calculated Fields
Post by: Craig 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

Title: Re: Calculated Fields
Post by: marko on January 05, 2006, 01:38:37 pm

I think so too :D