Print

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

[Quixote]

The literal key used with a comma (/,) inside an IF expression is not returning a comma literal:

Example (Filename from Properties):

     [Album Artist]\If(IsEmpty([mySeries#]),,Book/, [mySeries#] - )[Album]

Returns:    Anne McCaffrey\0DragonSong
Expected:  Anne McCaffrey\Book, 1 - DragonSong


It looks like the expression is interpreting the last comma as part the of parameter delimiters.

[Matt]

Your expression (modified slightly to use fields I have) works.  The comma's come through alright.

I'm guessing the issue is that "IsEmpty(...)" is doing a string empty test, and "0" is not empty.

To do a numeric empty test, use:
IsEmpty([mySeries#], 1)

Let us know if this shores it up.

[Quixote]

I'm getting the same results only now I'm getting a 1 instead of a 0:

Example (Filename from Properties):

Using the Directories->Rule
     [Album Artist]\If(IsEmpty([mySeries#],1),,Book/, [mySeries#] - )[Album]

Returns:    Anne McCaffrey\1DragonSong
Expected:  Anne McCaffrey\Book, 1 - DragonSong

HOWEVER:
Using the formula in the Filename->Rule I get the Expected result using either IsEmpty() string or numeric functions (the field is defined as a String).

So the issue seems to be contained only in the Directories->Rule part of the dialog.

[marko]

change the isempty to isequal...

[Album Artist]\If(Isequal([mySeries#],unknown,8),,Book/, [mySeries#] - )[Album]

see if that helps..

[Matt]

Empty [myExpression#] becomes "Unknown My Expression" in a directory rule.  You'll have to do some legwork to side-step this.

Marko beat me to it.  He's right.

[marko]

IsEmpty([field],0) is not returning "1" on empty string fields

Renaming this file using IsEmpty([Artist]) should return a "1".  Notice the artist field is empty.


Returns a "0" instead.

try using the following:

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

it says, "if [artist] is empty, use 1, otherwise, use [artist]"

You should see your file renamed to "unknown artist.jpg". Use isequal([artist],unknown,8) to get past this one.

This only applies for the rename from properties tool. If you try these two expressions in the search box, you will see the results you expect...

[=isempty([artist])]=1
[=isempty([artist])]=0

-marko.