INTERACT FORUM
More => Old Versions => Media Center 15 (Development Ended) => Topic started by: exodus1977 on September 15, 2010, 08:17:44 pm
-
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.
-
Try
If(IsEqual([done],Yes,1),If(IsEqual([video type],Movie,1),Move to new directory,Don't move),Don't move)
-
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.
If(IsEqual([video type],Movie,1),If(IsEqual([done],Yes,1),[Genre]\[Album Artist (auto)]\[Album]\),)
ETA: Beat by mere seconds!
-
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?
-
Thanks for all the help guys. The Math() function is interesting, as it would be pretty logical and/or commands.
-
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.
-
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().
-
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?