Can someone tell me what I'm doing wrong? I'm trying to get JRiver to auto-name all my files differently depending on whether there is a value in the [Disc #] field. Specifically, where there is no [Disc #], I want it to use PadNumber([Track #],3) so that the tracks list out as 001, 002, 003, etc. (I have some digital albums with 100+ tracks). If there is a value in the [Disc #], I want it to use PadNumber([Disc #],2)-PadNumber([Track #],2) so it lists out as 01-01, 01-02. This will allow legacy MP3 players, burned MP3 CDs, etc. that go in order by filename to play in the correct order.
In order to do this, I've constructed an expression to test for whether there is a value in the [Disc #], and depending on whether it is empty, use the appropriate expression:
If(IsEmpty([Disc #]),PadNumber([Track #],3),PadNumber([Disc #],2)-PadNumber([Track #],2))-[Name]
The problem is, when [Disc #] is empty, it treats it as [Disc #] = Unknown Disc, so I get Unknown Disc -01, Unkown Disc -02, instead of 001, 002.
When I use If(IsEqual([Disc #],Unknown Disc) ... that fails as well. Any hints here?
-Aaron