# Regular Expressions **URL:** https://community.mp3tag.de/t/regular-expressions/521 **Category:** Howto **Created:** [October 16, 2003, 4:47pm UTC](https://community.mp3tag.de/t/regular-expressions/521 "2003-10-16T16:47:29Z") **Posts on this page:** 1 **Showing post:** 46
### Author: ![DetlevD](https://community.mp3tag.de/user_avatar/community.mp3tag.de/detlevd/32/123_2.png) [@DetlevD](https://community.mp3tag.de/u/DetlevD) #### Post date: [August 1, 2011, 2:03am UTC](https://community.mp3tag.de/t/regular-expressions/521/46 "2011-08-01T02:03:44Z")
**Convert from RFC822/1123 Date string to ISO-8601 Date string.** Examples: RFC822/RFC 1123 ==\> ISO-8601 1 Feb 2009 ==\> 2009-02-01 30 Sep 2010 ==\> 2010-09-30 **$replace($regexp($right('0'%YEAR%,11), '(\d{1,2}) (Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec) (\d{2,4})','$3-$2-$1'), 'Jan','01','Feb','02','Mar','03','Apr','04','May','05','Jun','06', 'Jul','07','Aug','08','Sep','09','Oct','10','Nov','11','Dec','12')** See also: [http://www.w3.org/Protocols/rfc822/](http://www.w3.org/Protocols/rfc822/) [http://www.freesoft.org/CIE/RFC/1123/99.htm](http://www.freesoft.org/CIE/RFC/1123/99.htm) DD.20110801.0623.CEST Example: 1 Feb 2009 HH:MM ==\> 2009-02-01 HH:MM **$replace($regexp($right('0'$cutRight(%YEAR%,6),11), '(\d{1,2}) (Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec) (\d{2,4})','$3-$2-$1'), 'Jan','01','Feb','02','Mar','03','Apr','04','May','05','Jun','06', 'Jul','07','Aug','08','Sep','09','Oct','10','Nov','11','Dec','12')$right(%YEAR%,6)** DD.20140310.2236.CET --- _[View the full topic](https://community.mp3tag.de/t/regular-expressions/521)._