Print

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

[raym]

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.

[gappie]

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.

[raym]

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.