INTERACT FORUM

Please login or register.

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

Author Topic: View Schema for specific directory / drives ?  (Read 1758 times)

Bob007

  • Regular Member
  • Recent member
  • *
  • Posts: 45
  • nothing more to say...
View Schema for specific directory / drives ?
« on: September 06, 2006, 02:53:29 pm »

Hi --

A simple enough question I think...except I can't figure it  >:(...and a quick search hasn't helped.

I have my music organised into different drives / directories based on the type of music it is i.e I have the following structure at a top level:

M:\[MC - Ripped CDs]\....etc....
M:\[MC - Live Bootlegs]\......etc...
N:\[MC - Studio Bootlegs]\....etc...

etc etc

I'm trying to create a View Scheme for each of these top-level directories but adding various combinations of the expressions FileName, FilePath, Mid into step 4 of the View Creation dialogue box aren't achieving what I want no matter what I try.

It can't be that hard -- any clues anyone?  It must be simple enough.

-- Thanks, Bob  ;D


Logged

Bob007

  • Regular Member
  • Recent member
  • *
  • Posts: 45
  • nothing more to say...
Re: View Schema for specific directory / drives ?
« Reply #1 on: September 08, 2006, 02:30:17 pm »

No replies but an update: I've worked out what my expression needs to be......but I can't get VIEW SCHEMA to be built at all.

I know that [Mid (FilePath ([Filename]) ,21,4) ] will resolve my FILEPATH to the word "Boot" i.e this is where my bootlegs are stored but if I try and create an expression in the create view dialogue similar to :

[Mid (FilePath ([Filename]) ,21,3) ]=[Boot]

it returns nothing.  I've played around with it - removing brackets etc but can't get it to work.

Any clues anyone?
Logged

marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 9139
Re: View Schema for specific directory / drives ?
« Reply #2 on: September 08, 2006, 02:45:53 pm »

Try:

[=isequal([filename],boot,8)]=1

Bob007

  • Regular Member
  • Recent member
  • *
  • Posts: 45
  • nothing more to say...
Re: View Schema for specific directory / drives ?
« Reply #3 on: September 09, 2006, 12:10:52 pm »

Thanks.  A bit of tweaking and that works a treat.

What's the value of '8' for?  It's not on the expressions page.
Logged

marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 9139
Re: View Schema for specific directory / drives ?
« Reply #4 on: September 09, 2006, 01:22:08 pm »

Nice one.
see: http://yabb.jriver.com/interact/index.php?topic=32964.msg226899#msg226899

it means: case insensitive substring search.

so if 'boot' appears in the filename field in any way shape or form, it will satisfy the search.
use '7' for case sensitivity.

Bob007

  • Regular Member
  • Recent member
  • *
  • Posts: 45
  • nothing more to say...
Re: View Schema for specific directory / drives ?
« Reply #5 on: September 12, 2006, 03:03:51 pm »

Thank you, sir.

Hey, I'm navigating with ease now.... ;D
Logged
Pages: [1]   Go Up