Print

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

[wynnytsky]

about a year ago I created an expression column that would take a stab at scoring a track's recording quality by giving weights to the two R128 values

Code: [Select]

ifelse(
    isempty([Dynamic Range (R128)]) or isempty([Volume Level (R128)]),
   
    -20,
   
    Math(
        RemoveRight([Dynamic Range (R128)], 3)
        +
        RemoveRight([Volume Level (R128)], 3)
        *
        if(
            isequal(Math(sign(RemoveRight([Volume Level (R128)], 3))), 1, 1),
           
            -0.5,
           
            2
        )
    )
)
I still reserve the star system for scoring tracks by how much you like them, and recording quality takes a back seat in that regard

[lepa]

Code: [Select]

ifelse(
    isempty([Dynamic Range (R128)]) or isempty([Volume Level (R128)]),
   
    -20,
   
    Math(
        RemoveRight([Dynamic Range (R128)], 3)
        +
        RemoveRight([Volume Level (R128)], 3)
        *
        if(
            isequal(Math(sign(RemoveRight([Volume Level (R128)], 3))), 1, 1),
           
            -0.5,
           
            2
        )
    )
)

Matt can correct me if I'm wrong but I don't think you can use "or" operator like that with MC's expression language. I would say that above probably only checks the first IsEmpty.
With new Number() function you don't need RemoveRight anymore although I suspect that Number() doesn't reserve sign.

[Matt]

Matt can correct me if I'm wrong but I don't think you can use "or" operator like that with MC's expression language. I would say that above probably only checks the first IsEmpty.
With new Number() function you don't need RemoveRight anymore although I suspect that Number() doesn't reserve sign.

There's no support for that, but I'm adding an Or(...) function right now because it's a good idea.  It will just test all the parameters listed and output true if any of them hit.

Here's the history:
NEW: Added the expression function Or(...) to test a list of values and output true if any are set.

[lepa]

There's no support for that, but I'm adding an Or(...) function right now because it's a good idea.  It will just test all the parameters listed and output true if any of them hit.

Here's the history:
NEW: Added the expression function Or(...) to test a list of values and output true if any are set.

This is a good addition, thanks!

[Matt]

And because I just wanted to be complete:
NEW: Added the expression function And(...) to test a list of values and output true if all are set.

[lepa]

Like this?
If(Or(IsEqual([Subtitles],Finnish,8), IsEqual([Subtitles],English,8)),TRUE, FALSE)

[Matt]

Like this?
If(Or(IsEqual([Subtitles],Finnish,8), IsEqual([Subtitles],English,8)),TRUE, FALSE)

Exactly.  I added ,1 to the end of the Or and it went from FALSE to TRUE on my test.

[lepa]

Cool, this will surely prettify some long chains

[wer]

Matt maybe it would be a good idea to lock this thread and make it a sticky, just for documentary purposes.  Your first post was a great summary! 

[Matt]

I'll branch the discussion.

[wer]

Matt about the new AND() and OR() functions.  It's not quite the same as the boolean support I was suggesting in the other thread because it can't be used infix, but my question is, is there any difference between using these new functions and just using Math() or are they just more readable shortcuts to the same thing?

[Matt]

Matt about the new AND() and OR() functions.  It's not quite the same as the boolean support I was suggesting in the other thread because it can't be used infix, but my question is, is there any difference between using these new functions and just using Math() or are they just more readable shortcuts to the same thing?

Math(...) is probably pretty similar.