INTERACT FORUM

More => Old Versions => Media Center 12 (Development Ended) => Topic started by: raym on August 01, 2007, 01:56:26 am

Title: MC Expression Gurus: need some help please?
Post by: raym on August 01, 2007, 01:56:26 am

I'm sure this should be do-able but I havn't been able to work it out...

I have a view scheme which shows all my TV recordings (dvr-ms files). All files are in the format: (YYYY-MM-DD) NAME.dvr-ms. What I'd like to be able to do is write an expression which groups all recordings that share the same name. Therefore, What I'm hoping to achieve is something like this:

TV SHOW                  NAME
The Sopranos         
                           (2007-02-11) The Sopranos.dvr-ms
                           (2006-02-03) The Sopranos.dvr-ms
                           (2006-01-27) The Sopranos.dvr-ms

CSI                       
                           (2007-02-11) CSI.dvr-ms
                           (2006-02-03) CSI.dvr-ms
                           (2006-01-27) CSI.dvr-ms

...
... etc

Any help is appreciated.

Thanks.

Title: Re: MC Expression Gurus: need some help please?
Post by: gappie on August 01, 2007, 02:10:19 am

im not sure if this is what you want. but you could make something like:
RemoveLeft(RemoveRight([Name],7),13) as an expresion or user library field.

Title: Re: MC Expression Gurus: need some help please?
Post by: raym on August 01, 2007, 03:23:33 am

Oh wow! Thanks Gappie (again!). This seems to do the trick on it's own: RemoveLeft([Name],12). Drilling down own more level gives me the full filename which is exactly what I was after.

Thanks for pointing this function out to me. I hadn't thought of using it.

Cheers.