INTERACT FORUM

More => Old Versions => JRiver Media Center 19 for Windows => Topic started by: kdwykleingeld on May 30, 2014, 12:41:44 am

Title: Fill Properties From Filename/Directory
Post by: kdwykleingeld on May 30, 2014, 12:41:44 am

Hi, i am trying to update some fields from my directory name and it seems that the replacement works from to back towards the front ..

I have a file structure with multiple levels of sub directories and i just want to use the upper directory in one of my fields..

c:\a\b\c\bla1.txt
c:\d\e\g\h\bla2.txt
c:\x\y\bla3.txt
c:\z\bla4.txt

i just want to set [Comment] to the highest dir name    so ..   "a" for the 1st ,  "d" for the 2nd etc

a filter such as [Comment]  always gives me the lowest level subdir     so .. "c" for the 1st ,   "h" for the 2nd ..

so.. any ideas how to do this ?

thx koen

Title: Re: Fill Properties From Filename/Directory
Post by: MrC on May 30, 2014, 12:46:41 am

Fill Properties is template based.  You might have better luck using the expression language and assigning to a field.  Use ListItem() on the Filename field, with backslash as the separator.  Ask if you need more help.

Title: Re: Fill Properties From Filename/Directory
Post by: kdwykleingeld on May 30, 2014, 12:53:08 am

hi thx,  i will have a look at that !!

however

i know its template based .. but how does the termplate allow me to wildcard out the lower level of subdirs ..

or is it always "absolute" from the lowest level and not possible this way at all ?   (with fill from filename/dir)

thx 

Title: Re: Fill Properties From Filename/Directory
Post by: MrC on May 30, 2014, 12:56:51 am

Each item consumes as much as it can, so long as the template matches.  So you'd need enough stuff after [comment] to force the position matches.

Title: Re: Fill Properties From Filename/Directory
Post by: kdwykleingeld on May 30, 2014, 12:59:36 am

ok thx.. with other words .. this does not work for my use case since i do not know how deep each directory is ..

anyways i will dig myelf into the expresssion field

thx

reg koen

Title: Re: Fill Properties From Filename/Directory
Post by: MrC on May 30, 2014, 01:05:46 am

Consider creating a new user field, which calculates the top level directory.  That way, you never have to do it again.

   Listitem([filename], 1, \)

Title: Re: Fill Properties From Filename/Directory
Post by: kdwykleingeld on May 30, 2014, 01:14:12 am

hi,  wow.. this was easy ..

fixcase(ListItem([Filename (path)],1,\),4)

did the job

thx !

reg koen

Title: Re: Fill Properties From Filename/Directory
Post by: kdwykleingeld on May 30, 2014, 01:23:13 am

just saw your syntax which is even more simple

thx again.. i will start using this functionality extensively !!

reg koen