INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: c1c9k72 on December 29, 2005, 09:49:28 am

Title: DB Expression question
Post by: c1c9k72 on December 29, 2005, 09:49:28 am

A little background: I'm working on a way to standardize my fields and filenames, so I'm breaking down the names of songs in the following way.

Artist: Main Artist
Featured Artist: Any other artist featured on the track (semi-colon delimited list)
Name: The song's title
Subtitle: Any variation identifier (Remix, Live, etc.)

In order to get the rename files from properties to work just so, I've created two new expressions:

Calculated Artist: if(IsEmpty([Featured Artists]),[Artist],[Artist] f. [Featured Artists])
Calculated Title: If(IsEmpty([Subtitle]),[Name],[Name] /([Subtitle]/))

Calculated Artist works perfectly.  However, Calculated Title is a bit glitchy.  It insists on adding a closing parenthesis to every title, regardless of whether it has a subtitle or not.  I've found it only does this with parenthesis, and not with braces.

Can anyone shed some light on the nature of the problem ?  I'd really prefer to use parenthesis, since that seems to be the standard everyone else uses.

Title: Re: DB Expression question
Post by: marko on December 29, 2005, 03:35:46 pm

I see the same problem here when trying to wrap the [date (year)] tag in parenthesis in an expression for the display bar.

Try adding a space between the last two closing parenthesis. I've found that this helps in some places but not in others.

I've also only found this to be an issue when I end the expression in this way, ie. the last item in the expression is to output in brackets ( ... )

I think there is a little bug lurking around in there somewhere.

Title: Re: DB Expression question
Post by: c1c9k72 on December 29, 2005, 06:20:38 pm

Thanks for the input, Marko.

I tried to invert the condition, but couldn't find a way to do that, so I abandoned the subtitle and went with just breaking up the artists.  It avoids the problem for me, but it's something that the programmers may want to take a look at.

Title: Re: DB Expression question
Post by: marko on December 30, 2005, 01:11:00 am

If(IsEmpty([Subtitle]),[Name],[Name] /([Subtitle]/))

I don't have subtitle, so I used [rating]

If(IsEmpty([rating]),[Name],[Name] /([rating]/))

and saw the same as you, a closing bracket appended to everything...
adding a space between the two at the end worked for me.

If(IsEmpty([rating]),[Name],[Name] /([rating]/) )

would be nice if it did get fixed.