Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[brainsoup]

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?  ?

[Matt]

It's a bug with the latest build.  It'll be fixed in a build or two.

[brainsoup]

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

[NoCodeUK]

Thanks for clarifying that one Matt!

Adam

[Craig]

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

[marko]

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]

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

[Craig]

Got it - I think

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

Craig

[marko]

I think so too