More > Media Center 17

Carnac - What does it do?

<< < (6/7) > >>

fitbrit:
Thanks for your answers, Matt.

rick.ca:

--- Quote from: fitbrit on October 25, 2011, 01:03:50 pm ---I'm clueless about this, but I imagine it should be possible to make a custom field, based on an expression, that will automatically take Carnac's Season and Episode format and put it in the format I want, including the letters etc.
--- End quote ---

Further to what Matt says, if you prefer to see "Sxx Exx" in a caption or in a file info panel, use SPadNumber([Season],2) EPadNumber([Episode],2). That's just an example. The point is, you're not likely to want to display things like [Season] or [Episode] in isolation, and will be using an expression anyway. You don't need to make a custom expression field, but may if that makes things easier. I use one like this for use in a Standard View column—simply because it's easier to read and saves space.

fitbrit:

--- Quote from: rick.ca on October 25, 2011, 04:49:01 pm ---Further to what Matt says, if you prefer to see "Sxx Exx" in a caption or in a file info panel, use SPadNumber([Season],2) EPadNumber([Episode],2). That's just an example. The point is, you're not likely to want to display things like [Season] or [Episode] in isolation, and will be using an expression anyway. You don't need to make a custom expression field, but may if that makes things easier. I use one like this for use in a Standard View column—simply because it's easier to read and saves space.

--- End quote ---

Thanks, Rick. They're exactly the expressions (separately) I've been using to rename my seasons/episodes within the respective fields. I just kind of recalled that one could make a custom expression field, and that might be just the compromise solution I've been looking for.

fitbrit:
If I may trouble someone again... how can I create an expression that will conditionally remain blank if the Season and Episode fields are both blank, or better still if only one is filled, it only shows the padded, lettered version of it?

rick.ca:
If(IsEmpty([Season]), , SPadNumber([Season], 2)/ )If(IsEmpty([Episode]), , EPadNumber([Episode], 2))

Note the handling of spaces. The expression language ignores spaces within functions, so they can be used to separate parameters for readability. So the space in ', ,' could be omitted—this means 'nothing' either way. Where a space is needed, it must be escaped with a '/'. Here, I've added a space after Season, and included it in the 'If' function so it's only added if there is a Season. On the other hand, there is no space separating the two 'If' functions—because we don't want '_E00' as a result when there is no Season.

Navigation

[0] Message Index

[#] Next page

[*] Previous page