Print

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

[james.smth]

In one of my views for video files i have an expression column with the following expression:
If(IsEmpty([Series]), [Name], [Series] S[Season]E[Episode] [Name])

However, when i paste this expression into 'filename rule' area of "Rename, Move, & Copy Files" window the output is the reverse of what it should be so i have to change the expression like this:
If(IsEmpty([Series]), [Series] S[Season]E[Episode] [Name], [Name])

[blgentry]

I can't test this at the moment, but I have a suggestion:

Make a custom field in the MC Library that holds this information.  Call it something like "SeriesName", or something else that makes sense to you.  As a calculated data field, it should act just like your expression column.

Except that now you can use it by name in the RM&C dialogs!  That should sort out the inconsistency I think.

Good luck.

Brian.

[james.smth]

I can't test this at the moment, but I have a suggestion:

Make a custom field in the MC Library that holds this information.  Call it something like "SeriesName", or something else that makes sense to you.  As a calculated data field, it should act just like your expression column.

Except that now you can use it by name in the RM&C dialogs!  That should sort out the inconsistency I think.

Good luck.

Brian.

Your suggestion worked, thank you.

[james.smth]

If i change this:

Code: [Select]

If(IsEmpty([Series]), [Name], [Series] S[Season]E[Episode] [Name])to this:

Code: [Select]

If(IsEmpty([Series]), [Name] ([Year]), [Series] S[Season]E[Episode] [Name])the output that should be Dark Phoenix (2019), for example, instead will become 1, SE Dark Phoenix)

Creating a custom library field doesn't help in this case. Something is not working properly.

[blgentry]

I'm not sure where that comma is coming from in "1, SE" .  What is the [Series] tag for the file in question?

I would use an expression column and show both the expression and the values of ALL of the tags in question, all side by side, so you can see what's going on.

Good luck.

Brian.

[james.smth]

It's a movie, so Series should be empty. I double-checked in the tag window and it appears to be empty.
So if i use this expression:

Code: [Select]

If(IsEmpty([Series]), [Name] ([Year]), [Series] S[Season]E[Episode] [Name])i get this: 1, SE Dark Phoenix)

And if i use this expression:

Code: [Select]

If(IsEmpty([Series]), [Name], [Series] S[Season]E[Episode] [Name])i get this: Dark Phoenix

So the question is why do i get 1, SE Dark Phoenix) instead of Dark Phoenix (2019). For some reason adding ([Year]) throws a wrench into it. The value of tag "Year" for this particular movie is "2019".

[james.smth]

If i use this expression:

Code: [Select]

If(IsEmpty([Series]), [Name] [Year], [Series] S[Season]E[Episode] [Name])it works fine

So it appears that adding ( or ) breaks it.

[Matt]

So it appears that adding ( or ) breaks it.

You need to escape the parenthesis with a slash (/).