INTERACT FORUM

Please login or register.

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

Author Topic: how to detect filename errors? (need expression expert)  (Read 2943 times)

rjm

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 2699
how to detect filename errors? (need expression expert)
« on: March 30, 2012, 11:15:28 pm »

For single artist audio music albums I try to rename the files [Track #] - [Name].

I want a filter to detect names that do not conform to this convention.

So far I have created the expression:

[=IsEqual(filename(,0),PadNumber([Track #],2) - [Name],0)]=0

which works except for those [Names] that have special characters like :?\ which are converted to _ by the file rename function.

How should the expression be modified to handle these special characters?
Logged

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Re: how to detect filename errors? (need expression expert)
« Reply #1 on: March 31, 2012, 12:38:30 am »

Here's a method.  Put it together how you want.  I tend to use Panes views to test and build.

Special chars /\:*?"<>| get converted to underbar (_) during Rename.

The Clean() function in mode 3 will clean file system special chars from a name.  Unfortunately, it cleans to use dash (-) rather than underbar (_), but you can correct for that in your expression.  The idea is to Clean() the name, and compare against filename with underbar replaced by dash (and you have to convert the underbar to dash in the filename() since converting dash to underbar in Name will also convert valid dash's in Name).

To test, I create one pane:

   Name: Contains FS Illegal char
   Expression: FormatBoolean(regex([Name], /#[\\/:*?"<>|]#/), Contains Illegal, Legal)

From there, a second column:

  Name: Name -> Cleaned
  Expression: [Name] -> Clean([Name], 3)

and finally a third:

  Name: Needs Update?
  Expression: If(IsEqual(PadNumber([Track #],2) - clean([Name],3), replace(filename(,0),_,-)), / **Path OK, [Name])

Logged
The opinions I express represent my own folly.

rjm

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 2699
Re: how to detect filename errors? (need expression expert)
« Reply #2 on: March 31, 2012, 01:44:01 am »

Thanks for pointing the way. I got it to work as a search list with the expression:

[=IsEqual(Replace(filename(,0),_,-),PadNumber([Track #],2) - Clean([Name],3),0)]=0
Logged

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Re: how to detect filename errors? (need expression expert)
« Reply #3 on: March 31, 2012, 10:35:53 am »

Great, good to hear.

It might be worth requesting a new mode to Clean(), perhaps 4, which changes the replacement character from dash (-) to underbar (_) so that this job is easier and matches Rename's functionality.

Name:                    Foo "Bar" Jones
Clean([Name], 3) => Foo -Bar- Jones
Clean([Name], 4) => Foo _Bar_ Jones
Logged
The opinions I express represent my own folly.

rjm

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 2699
Re: how to detect filename errors? (need expression expert)
« Reply #4 on: March 31, 2012, 12:59:32 pm »

Yes, that would be a nice enhancement.

Even better would an "expand to full artist" smartlist option.

Maybe Matt is eavesdropping.
Logged

rjm

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 2699
Re: how to detect filename errors? (need expression expert)
« Reply #5 on: March 31, 2012, 02:50:22 pm »

I just figured out that it is possible to use the "expand to full album" option for artist related applications provided you do not need info associated with (Multiple Artist) albums. An "expand to full artist" option would be nice to cover all possibilities.
Logged

glynor

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 19608
Re: how to detect filename errors? (need expression expert)
« Reply #6 on: June 14, 2012, 09:41:49 pm »

I need to do the same thing but have it apply to an entire expression that I already have.  So, to be specific, I have this the custom expression field [iTunesFileKey] which is:

M:\iTunes_cache\[Handheld Audio Path]\if(regex([Filename (name)],/#\.(mp3|mp4|m4a|m4v|m4p|m4b|m4r|jpg)$#/),[Filename (name)],Filename(,0).mp3)

[Handheld Audio Path] is, itself an expression:

Audio\If(IsEmpty([Media Sub Type]),Music,[Media Sub Type])\If(IsEmpty([Artist]),Unknown,[Artist])\If(IsEmpty([Album]),Unknown,[Album])If(IsEmpty([Disc #],1),,\[Disc #])

I need to check that whole thing for invalid filename characters and have them converted to _ as MC will do when it syncs the handheld.  But, obviously, I need the colon after M to stay as it is.  I've also noticed that MC seems to be converting ampersand characters to &amp; in my expression, but these come through in the actual filename as ampersands.  (On second thought, this might just be the logging in MCiS that is doing that.)

A "Filename Friendly" mode for Clean() would be so much simpler, and would be fantastic.  But, barring that, can anyone help?  I'm hopelessly lost as to how this would apply to my need.
Logged
"Some cultures are defined by their relationship to cheese."

Visit me on the Interweb Thingie: http://glynor.com/

glynor

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 19608
Re: how to detect filename errors? (need expression expert)
« Reply #7 on: July 23, 2012, 04:19:24 pm »

Anyone?  Bueller?

Also, to reiterate, a nice new feature would be a Clean() mode that matches the output of MC's Filename logic.
Logged
"Some cultures are defined by their relationship to cheese."

Visit me on the Interweb Thingie: http://glynor.com/

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Re: how to detect filename errors? (need expression expert)
« Reply #8 on: July 23, 2012, 07:34:47 pm »

See this post and replies.
Logged
The opinions I express represent my own folly.

glynor

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 19608
Re: how to detect filename errors? (need expression expert)
« Reply #9 on: July 23, 2012, 08:11:22 pm »

Awesomesauce.
Logged
"Some cultures are defined by their relationship to cheese."

Visit me on the Interweb Thingie: http://glynor.com/
Pages: [1]   Go Up