Print

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

[chris13]

Hello Forum,

i have a question about expression language. Maybe someone could help me with this.

For tagging my audio collection i use additional fiels, like:

[Release Type 2]
Here i type in some information like
Remastered
Reissued


[Release Type 3]
Here i type in some information like
Collectors Edition
Deluxe Edition
Enhanced
Box Set


I have another Field called [Album Enhanced]
In this field all information regarding [Release Type 2] and [Release Type 3] shall be displayed if available.

like this: [Album] ([Release Type 2] [Release Type 3])

I know the function !isempty but i am struggling to implement this to get the correct result for all combiantions.

Examples:
Remastered Deluxe Edition --> all fields with values
...And Justice for All (Remastered Deluxe Edition)

Remastered Edition --> only [Release Type 2] with value
...And Justice for All (Remastered)

Original Editiion --> no values in Release Type 1 and 2
...And Justice for All


Thanks for your support!

[RoderickGI]

You can test the field for being not empty, or being empty, and just change around where the field is set.

if(!isempty([Release Type 2], 0), [Release Type 2],,)

OR

if(isempty([Release Type 2], 0),, [Release Type 2])

https://wiki.jriver.com/index.php/Conditional_Functions#If.28.E2.80.A6.29
https://wiki.jriver.com/index.php/Test_and_Comparison_Functions#IsEmpty.28.E2.80.A6.29


You can also use the ifelse function to simplify a bit.

ifelse(!isempty([Release Type 2], 0), [Release Type 2])
and
ifelse(!isempty([Release Type 3], 0), [Release Type 3])

https://wiki.jriver.com/index.php/Conditional_Functions#IfElse.28.E2.80.A6.29


As you want to include brackets in the output, you also need to "escape" each bracket around the Release Types you are adding, using the escape character "/" so that MC doesn't treat them as part of the expression;

/(  and /)

But then you don't want the brackets showing if neither Release Type 2 or 3 have content.
ifelse(!isempty([Release Type 2][Release Type 3], 0), /()

Will yield an opening bracket "(" if either [Release Type 2] or [Release Type 3] contain any value.

Similar expression section for the closing bracket.
ifelse(!isempty([Release Type 2][Release Type 3], 0), /))


So the full expression using the ifelse command would be;


[Album] ifelse(!isempty([Release Type 2][Release Type 3], 0), /()ifelse(!isempty([Release Type 2], 0), [Release Type 2]) ifelse(!isempty([Release Type 3], 0), [Release Type 3])ifelse(!isempty([Release Type 2][Release Type 3], 0), /))


Or in indented form;

[Album]
ifelse(
   !isempty(
      [Release Type 2][Release Type 3], 0
   ), /(
)
ifelse(
   !isempty(
      [Release Type 2], 0
   ), [Release Type 2]
)
ifelse(
   !isempty(
      [Release Type 3], 0
   ), [Release Type 3]
)
ifelse(
   !isempty(
      [Release Type 2][Release Type 3], 0
   ), /)
)

[chris13]

Thank you for the solution and also for taking the time to give a great explanation!
The expression works great. Only one minor problem is left.

If only one field is populated with a value a blank inside the bracket is left.

For example:
...And Justice for All (Remastered )

If you have any further idea, your support is much appreciated.

[blgentry]

If you have a single space in some of your fields, you might be able to automatically remove them using the function:  Library Tools > Clean File Properties .

You might try it on one song or album and see how it works.  Then use it on everything if it works as you expect it to.

Make sure to select the function(s) that you want applied as "clean file properties" has several modes and features.

Brian.

[chris13]

As far as i can tell there is no space in the fields. The space is inserted by the expression, if one of the two fields is empty. Don't know why  ?

For simplicity i just use one field for now "Release Type 2" which contains all information, e.g. Remastered Deluxe Edition.
I just used the expression you have posted and modified a little bit.

[Album] ifelse(!isempty([Release Type 2]), /([Release Type 2]/))

This works without insertion of a space.

Thanks again for support

[RoderickGI]

Oops. I thought I had tested for correct spaces, but I must not have. I wasn't testing using your fields of course, so I may have mucked something up in testing and converting the expression to your field.

You can still use the two fields as you have previoously. Not a big deal to fix the expression. In fact, there are lots of ways to do it, but I decided to use the "Clean" function. Look that up in the Wiki about the Expression Language.

So here it is. Spaces work correctly with the data I was looking at. I was using [Artist] and [Genre] fields to test against, and my Genre sometimes had addition characters in it, such as "Pop/Rock", but I made those work as well.

Clean([Album]ifelse(!isempty([Release Type 2][Release Type 3],0),/ /()Clean(ifelse(!isempty([Release Type 2],0),[Release Type 2])ifelse(!isempty([Release Type 3],0),/ [Release Type 3]))ifelse(!isempty([Release Type 2][Release Type 3],0),/)))


Note that I removed all spaces from the expression itself unless they were actually required, which makes reading it a little harder, but making sense of it a little easier.


Mind you, Brian could probably write a Regex expression that did it in a much shorter form. But the above works, whether there are values in [Release Type 2] or [Release Type 3] or both.

Try it.

[chris13]

Great, it works! 

Thanks alot!