Print

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

[EpF]

I've been trying to create expressions that I can store in calculated fields which contain file paths for renaming files, but the back-slashes keep getting converted to underscores in the 'rename, move and copy' dialogue.

For example, I have this expression:

Code: [Select]

if(isequal([media type],Video),
    if(isequal([sub-type],Film),
        if(isempty([series title]),
            Film/\[name],
        Film/\[series title]/\[episode #] - [name]),
    if(isequal([sub-type],TV Show),
        TV Show/\[tv show]/\[series #],
    MISC/\[sub-type]/\[artist]/\[album])
    ),
[filename])

When I use that expression in a calculated field called 'Move Video File', the escaped back-slashes show up correctly when the field is used in a panes display, but in the 'Rule:' section of 'Directories' when using 'Rename, Move & Copy', the back-slashes become underscores which means the field can't be used for renaming.

Anyone have a way around this, or am I doing something wrong?

Edit: I know you can additionally use 'Find & Replace' to replace the underscores with back-slashes, but because any other punctuation marks in the filenames (like question marks, excalmation marks or colons - common enough in media names) get turned into underscores as well, this messes up the directory structure of a lot of files - is there a way to get back-slashes to show up literally in filenames when they come from calculated fields?

[MrC]

Include

Replace([your calculated field here],_,\)

in your Directories Rule.

[EpF]

Cheers MrC! I was just about to post the same thing back!