Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[exodus1977]

ok... I can't figure this out and need some help.  I'm trying to create an expression to rename files and I want multiple test conditions to be met.  I have two fields I want tested:

[done] I use this field to indicate that I have entered all the tags and the file is ready to be moved
[video type]  This indicates if its TV, Movie, etc.

I'm trying to do something like this:

if(isequal([done],Yes,1) and isequal([video type],Movie,1),Move to new directory,Don't move)

In other words, the file only gets moved to the new directory if [done]=yes and [video type]=Movie.  If either doesn't match, i don't want the file moved. 

Any ideas?  Thanks.

[221bBS]

Try

Code: [Select]

If(IsEqual([done],Yes,1),If(IsEqual([video type],Movie,1),Move to new directory,Don't move),Don't move)

[zxsix]

This should do it.  I'm not at my media computer at the moment so I can't test the syntax.
The section where it starts with [Genre] is the path you want the files moved to if both conditions are true.

Code: [Select]

If(IsEqual([video type],Movie,1),If(IsEqual([done],Yes,1),[Genre]\[Album Artist (auto)]\[Album]\),)
ETA: Beat by mere seconds!

[Matt]

221bbs gave a good solution.

You can also use Math(...) to do the logical operators & and |.

I did a little test using the album I'm listening to now which worked fine:
If(Math(IsEqual([Artist], Greg Brown, 1) & IsEqual([Name], Smell Of Coffee, 1)), Match, No Match)

I suppose we could also add And(...) and Or(...) functions for ease.  It's never been requested before.  Thoughts?

[exodus1977]

Thanks for all the help guys.  The Math() function is interesting, as it would be pretty logical and/or commands.

[)p(]

I suppose we could also add And(...) and Or(...) functions for ease.  It's never been requested before.  Thoughts?

Yes please! Feels much more natural. I am for anything that makes the expression more readable...longer expressions as they are now are pretty hard to read.

[exodus1977]

221bbs gave a good solution.

You can also use Math(...) to do the logical operators & and |.

I did a little test using the album I'm listening to now which worked fine:
If(Math(IsEqual([Artist], Greg Brown, 1) & IsEqual([Name], Smell Of Coffee, 1)), Match, No Match)

I suppose we could also add And(...) and Or(...) functions for ease.  It's never been requested before.  Thoughts?

Math() is a good tool for me.  And() Or() would be great to.  I almost got the expression correct, but after looking at 221bbs's code (which worked), I clearly got tripped up trying to nest if() within another if().   

[221bBS]

I clearly got tripped up trying to nest if() within another if().

I had the same problem when I started learning expressions. I've learned that using Notepad++ and breaking down the code helps me read it a lot better. Like the code above would be broken down like this

If(
   IsEqual([done],Yes,1)
   ,
   If(
      IsEqual([video type],Movie,1)
      ,
      Move to new directory
      ,
      Don't move
      )
   ,
   Don't move
)

I suppose we could also add And(...) and Or(...) functions for ease.  It's never been requested before.  Thoughts?

This would help me a lot.

I did a little test using the album I'm listening to now which worked fine:
If(Math(IsEqual([Artist], Greg Brown, 1) & IsEqual([Name], Smell Of Coffee, 1)), Match, No Match)

Haven't started using the Math function because I haven't learned how to use it yet. anyone else want to post some Math codes for me to get an idea of how it's used?