INTERACT FORUM

Please login or register.

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

Author Topic: Expression question  (Read 1645 times)

DJ_Hazelwood

  • Regular Member
  • Galactic Citizen
  • ****
  • Posts: 294
Expression question
« on: November 06, 2006, 09:00:23 am »

Hi,

i try to set up view schemes with the following expression rules

Scheme 1: Artist name starting with A .... F
Scheme 2: Artist name starting with G .... L
Scheme 3: Artist name starting with M .... R
Scheme 4: Artist name starting with S .... Z

I created a view scheme with the filter:

IsRange (Mid ([Artist]) , A - F)

but it displays no results.

The library has 35.000 files and there MUST be Artists starting with A .... F

So what is wrong?  (using MC 12.0.106)


Thanks in advance for your help.



Logged

marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 9143
Re: Expression question
« Reply #1 on: November 06, 2006, 09:19:47 am »

If you're talking about step 4 of the edit viewscheme dialogue, then use the format:

[=isrange(mid([artist]),a-f)]=1

DJ_Hazelwood

  • Regular Member
  • Galactic Citizen
  • ****
  • Posts: 294
Re: Expression question
« Reply #2 on: November 06, 2006, 09:41:03 am »

Thanks Marko, that's exactly what i was looking for.


After editing my view schemes one problem is still there:

the additional scheme

[=isrange(mid([artist]),0-9)]=1

shows all my files, not just the artists starting with 0 ... 9


EDIT: it works with [=isrange(mid([artist]),1-9)]=1, but not with [=isrange(mid([artist]),0-9)]=1
Logged

marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 9143
Re: Expression question
« Reply #3 on: November 06, 2006, 10:07:50 am »

Do you really need all those viewschemes? If there's a good reason, just ignore me, but, for me, less clutter is always better, so...

If you create one view scheme, and make the first pane an expression based pane, and use the following:

if(isequal([album artist (auto)],/(multiple,8),/(Various/),
if(isrange(mid([album artist (auto)]),a-f),A - F,
if(isrange(mid([album artist (auto)]),g-l),G - L,
if(isrange(mid([album artist (auto)]),m-r),M - R,
if(isrange(mid([album artist (auto)]),s-z),S - Z,
formatrange([album artist (auto)],999)))))

you get:

Again, I find here that plain old [artist] can get badly queered by all the VA albums, so I set that up to seperate them away from the rest. If you really want all artists regardless, use:

if(isrange(mid([artist]),a-f),A - F,
if(isrange(mid([artist]),g-l),G - L,
if(isrange(mid([artist]),m-r),M - R,
if(isrange(mid([artist]),s-z),S - Z,
formatrange([artist],999))))

better, yes? no?

DJ_Hazelwood

  • Regular Member
  • Galactic Citizen
  • ****
  • Posts: 294
Re: Expression question
« Reply #4 on: November 06, 2006, 10:23:18 am »

That's cool.  8)

I've created a view scheme like this.
And i will save it and use it as a base scheme for more tests and getting more experience with expressions.

But what i want to do with these view schemes is to export the lists based on the scheme to html.
If i export my library into one huge html-file it gets to big for browsing, so i tried to split it.

I know this isn't really a comfortable way.
And if there is another method to export a library (mp3) into html please let me know.

I think there was a plugin for exporting data into xml and transforming it with xslt.
But this has been a long time ago and i don't know it this works with the current MC-versions.

 



Logged
Pages: [1]   Go Up