INTERACT FORUM

Please login or register.

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

Author Topic: Help With "IsEmpty()" Expression  (Read 955 times)

miserythemexican

  • Recent member
  • *
  • Posts: 24
Help With "IsEmpty()" Expression
« on: September 19, 2009, 08:48:10 am »


i have just added the field [Remix] to contain the name of the remixing artist, if any, and want something like this --If(IsEmpty([Remix]),,[Remix] Remix)-- on the end of my current filename rule so that if a track has an artist name in [Remix] it appends the filename with "<so-and-so> Remix", otherwise leaves the filename as is. But for tracks with a blank [Remix] field this expression still appends "Unknown Remix Remix".

For two tracks, one with a string in [Remix], one with the field blank
If(IsEmpty([Remix]),true,false) returns false for both, and
If(IsEmpty([Remix], 1),true,false) returns true for both

Can anybody offer a correction for me because i cant for the life in me see where i've gone wrong!

 ?
Logged

gappie

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 4566
Re: Help With "IsEmpty()" Expression
« Reply #1 on: September 19, 2009, 09:09:09 am »

you could try

If(IsEmpty([Remix,0]),,[Remix] Remix)

if that does not work maybe:

If(isequal([Remix],Unknown,7),True,False)

 :)
gab
Logged

miserythemexican

  • Recent member
  • *
  • Posts: 24
Re: Help With "IsEmpty()" Expression
« Reply #2 on: September 19, 2009, 10:32:52 am »

The former of those works a treat...

I guess MC formats a blank fields to 'Unknown...'. Kinda makes sense. I had the same problem with IsEmpty([Year]) and used IsRange() instead but IsEmpty([Year], 1) works too.

Cheers for that gab!
Logged
Pages: [1]   Go Up