Ereg

[Anon]

Hi,

I have to fix a mysql dump file because the time field is not delimited (with '') and I can't import the file anymore...

How could I tell php to quote an expression composed by 2 numbers followed by : followed by 2 numbers : 2 numbers
ie 12:54:00 should become '12:54:00' ?

[brandonschnell]

theres probably a better way to clean up the file but heres a way to do it with ereg:

$clean_str = ereg_replace ("[0-9][0-9]:[0-9][0-9]:[0-9][0-9]", "'\0'", "$old_str")