INTERACT FORUM

More => Old Versions => JRiver Media Center 18 for Windows => Topic started by: nickeaston on February 13, 2013, 03:45:10 pm

Title: Need Expression Help--making file dates sortable
Post by: nickeaston on February 13, 2013, 03:45:10 pm

I have about 20,000 .mp3 files where the date is in the form of:  February 2, 2013 (spoken word episodes)

I need to end up with a new tag that is sortable; 2013-02-02.  (year-month-day)

Is this task "expression"-able?

Title: Re: Need Expression Help--making file dates sortable
Post by: MrC on February 13, 2013, 05:20:30 pm

Where is the date exactly - the filename?  The track's title?  Show a sample or two please, and I'll provide a solution.  I assume you want the date stored in the Date field for later use.

Title: Re: Need Expression Help--making file dates sortable
Post by: nickeaston on February 14, 2013, 12:14:17 pm

Existing tag structure:

Name=Coast To Coast AM - Feb 13 2013 - Hour 1
Artist=..........
Album=February 13, 2013
Genre=Speech
etc.

I need the 'Album' tags converted to the sortable format 2013-02-13 and then I can add the episode (Hour) and reassemble the filename and name to make sortable sense.

(I realize that this can be done in MC by breaking down the various components into new fields and reassembling to suit, and in fact did so several years ago, but lost my notes.)

Title: Re: Need Expression Help--making file dates sortable
Post by: MrC on February 14, 2013, 12:28:54 pm

This will pull the date out of your Name field:

   formatdate(ConvertDate([Name]), year-MM-dd)

Use this for an expression column.

But you can assign directly to the Date field:

   =ConvertDate([Name])

Same thing with Album - just change Name above to Album.