IPB

Welcome Guest ( Log In | Register )

> Notice!

Please take a minute to check our Frequently Asked Questions. Use Search to reveal possible related topics.

Also make sure you've read the Forum Guidelines before posting in this forum.

> Date format conversion, iTunes YEAR format -> DD-MM-YYYY
Solance
post Apr 21 2017, 11:18
Post #1


Member


Group: Full Members
Posts: 12
Joined: 21-April 17
Member No.: 23336
Mp3tag Version: 2.81



Looking for a little help.
Need to take date data from (YEAR) field in (YYYY-MM-DDTHH:MM:SS) format and move it to (RELEASETIME) field in (DD-MM-YYYY) format.
Something like "2017-04-16T07:00:00Z" to "16-04-2017"
Any advice? huh.gif
Go to the top of the page
 
+Quote Post
 
Start new topic
Replies
Solance
post Apr 21 2017, 13:43
Post #2


Member


Group: Full Members
Posts: 12
Joined: 21-April 17
Member No.: 23336
Mp3tag Version: 2.81



ok so this (DD-MM-YYYY) format is "broken" for (RELEASETIME) field.
but it always could be added in (COMMENT) or somewhere else, so is there a way to convert date somehow?
Go to the top of the page
 
+Quote Post
ohrenkino
post Apr 21 2017, 13:51
Post #3


Member


Group: Full Members
Posts: 9015
Joined: 9-December 09
From: Norddeutschland / Northern Germany
Member No.: 11458
Mp3tag Version: 2.84a



ZITAT(Solance @ Apr 21 2017, 14:43) *
ok so this (DD-MM-YYYY) format is "broken" for (RELEASETIME) field.
but it always could be added in (COMMENT) or somewhere else, so is there a way to convert date somehow?

Create an action of the type "Format value" for COMMENT or somewhere else.
Format string: $regexp('2017-04-16T07:00:00Z',(\d+)-(\d+)-(\d+)T.*,$3-$2-$1)

Instead of the '2017-04-16T07:00:00Z' part of the expression set the source field name, e.g. %year%.


--------------------
42 - wie war die Frage / what was the question / quelle était la question
Go to the top of the page
 
+Quote Post
Solance
post Apr 21 2017, 15:08
Post #4


Member


Group: Full Members
Posts: 12
Joined: 21-April 17
Member No.: 23336
Mp3tag Version: 2.81



QUOTE (ohrenkino @ Apr 21 2017, 15:51) *
Create an action of the type "Format value" for COMMENT or somewhere else.
Format string: $regexp('2017-04-16T07:00:00Z',(\d+)-(\d+)-(\d+)T.*,$3-$2-$1)

Instead of the '2017-04-16T07:00:00Z' part of the expression set the source field name, e.g. %year%.

perfect, exactly what I needed, problem solved.
thanks a lot! laugh.gif
Go to the top of the page
 
+Quote Post

Posts in this topic


Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 22nd September 2017 - 05:35