Print

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

[JaredH]

Ok, I'll try to ask this without being my usual wordy self.

I want to adjust the following DB Expression for Directory naming so that when I am renaming files whose [Type]=Singles, the directory naming structure ignores the [Album] tag and places the files in a simple [Artist] directory.

IF(IsEmpty([Disc #],1), [Audio Type]\[Type]\[Genre]\[Artist]\[Album],[Audio Type]\[Type]\[Genre]\[Artist]\[Album]\Disc [Disc #]


I also want to adjust the following DB Expression for File naming so that when renaming files whose [Type]=Singles, the file naming structure changes to [Artist] - [Name]

If(IsEmpty([track #], 1), [Artist] - [Name],[Artist] - [Track #] - [Name]


Help?

[KingSparta]

Looks Complex

Make Sure you have the Latest Version Of MC11.1 I think they fixed a few things in the Expressions Area.

[JaredH]

Yeah, been running 11.1 since the early Alpha stage. I have no idea how to format those DB Expressions. There's a few people on the board who are well versed in the DB Expression language. I'm hoping they will chime in soon.

[marko]

Hi JaredH, thanks for the updated icons, btw

this should work for directories, assuming that no track of type 'singles' has a [disc #]...

if(isequal([type],singles,1),[Audio Type]\[Type]\[Genre]\[Artist]\,if(isempty([Disc #],1),[Audio Type]\[Type]\[Genre]\[Artist]\[Album],[Audio Type]\[Type]\[Genre]\[Artist]\[Album]\Disc [Disc #]))

.......

and this should do your filenames...

if(isequal([type],singles,1),[Artist] - [Name],if(isempty([track #],1),[Artist] - [Name],[Artist] - [Track #] - [Name]))

.......

I've not tested them, but they should, hopefully, work.
let me know if there's a problem

[JaredH]

Just the man I was hoping to hear from. You certainly work some magic with these DB Expressions.

A thousand thank yous go out to you marko.

[gk666999]

This is very useful. I tried to do this earlier, but "Rename Files from Properties" dialog did not support advanced DB expressions. now's the time I dig out my saved expressions and give it a shot once more. Though technically it isn't  smartlist, but I'd suggest to post it to "Share your favourite smartlist" thread.