INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: MC Expression Gurus: need some help please?  (Read 702 times)

raym

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 3583
MC Expression Gurus: need some help please?
« 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.
Logged
RKM Smart Home - www.rkmsmarthome.com.au
Z-Wave Home Automation

gappie

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 4566
Re: MC Expression Gurus: need some help please?
« Reply #1 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.
Logged

raym

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 3583
Re: MC Expression Gurus: need some help please?
« Reply #2 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.
Logged
RKM Smart Home - www.rkmsmarthome.com.au
Z-Wave Home Automation
Pages: [1]   Go Up