INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: MrC on March 19, 2006, 02:44:52 pm

Title: Excel-style functions in path specifications?
Post by: MrC on March 19, 2006, 02:44:52 pm

Hello,

I'm trying to use AlbumArist (when it exists) instead of Artist inside the path specification under:

   Options->Handheld->Files and Paths->Audio Path

so that I can transfer files to end up in an [AlbumArtist] folder instead of an [Arist] folder.

Currently, I'm trying:

   If(IsEmpty([AlbumArtist]), [Artist], [AlbumArtist])\[Album]\

but that always seems to evaluate to '[AlbumArtist]', and not the field value based on the conditional.

Is this supposed to work, and if so, what am I doing wrong?

Title: Re: Excel-style functions in path specifications?
Post by: marko on March 19, 2006, 03:22:15 pm

how about you forget all about expressions for this one (akin to using a sledgehammer to crack a nut) and simply use the [album artist (auto)] field instead of [artist]?

If everything's tagged right, that ought to work for you. I can't say it will work as I don't use those handheld options. I do think the chances are of it working are good though.

for future reference, the following expression should produce the results you're after:

if(isempty([album artist],1),[artist]\[album],[album artist]\[album])

Title: Re: Excel-style functions in path specifications?
Post by: MrC on March 19, 2006, 06:44:16 pm

Thanks.  I wasn't sure if [album artist (auto)] would work, but it does once I ensure that all "Multiple Artists" tags were set to "Various Artists" as I wanted for consistency.  Its working fine.

Not knowing how the parser was working, I was expecting concatenation to work with my "if" expression, but see that I need to include the return paths inside the "if".  Thanks for clarifying.