Print

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

[nickeaston]

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?

[MrC]

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.

[nickeaston]

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.)

[MrC]

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.