regex to format a date for mysql... separated with hyphens 1

[pushyr]

i'm trying to format a date for mysql

the date is is currently 20100201 but i'd like to format it as 2010-02-01, separated with hyphens

what would be the ideal regex code to do this?

 

[jpadie]

@feherke
I read Pushyr as saying (at marker 11 Feb 0645) that the universe of possible file names excluded any date separators. hence the substr solution.

I wholly agree that if there is an arbitrary separator to take account of then this must also be dealt with, most probably in a regex.

however the regex is complicated (not fatally so) by the new bit of information that immediately preceding the date pairs we can also have more digits.

so a pattern would be something like

$pattern = '/(\d{8})[.-]?(\d{8})\.csv$/i';

 

[feherke]

Hi

So the modification of the problem posted at 11 Feb 10 5:40 is revoked ? Hmm... I understood that 11 Feb 10 6:45 is an addition to all previous. I think I am confused.

Feherke.

http://free.rootshell.be/~feherke/

 

[jpadie]

if it is an addition then preg_match is the way to go for sure. the pattern i posted above should work and is only a minor tweak to yours to deal with the variable prefixes.