INTERACT FORUM

Please login or register.

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

Author Topic: Excel-style functions in path specifications?  (Read 969 times)

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Excel-style functions in path specifications?
« 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?
Logged
The opinions I express represent my own folly.

marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 9139
Re: Excel-style functions in path specifications?
« Reply #1 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])

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Re: Excel-style functions in path specifications?
« Reply #2 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.
Logged
The opinions I express represent my own folly.
Pages: [1]   Go Up