Posted by Bob Palma on 04/20/05 17:22

I have a database field that I need to read and do some conversion on.
Here is what the raw data from the database looks like:

--
1084751309jpenaDisney Vignette Fleximon disk utilization
alert C:\ at 85%1084799703bpalmafixed.1084799713bpalmaclosed
--

After conversion, it should look like this:

--
5/16/2004 7:48:29 PM jpena
Disney Vignette Fleximon disk utilization alert C:\ at 85%

5/17/2004 9:15:03 AM bpalma
fixed.

5/17/2004 9:15:13 AM bpalma
closed
--


I have tried to use eregi_replace to convert the timestamps to DateTime,
but I end up with all three timestamps being changed to the same time
(5/16/2004 7:48:29 PM).

Here is the quick, albeit ugly, code I've tried to come close

--
$worklogt3 = eregi_replace("","<br>", $worklogt1);
$worklogt4 = eregi_replace("","<br><br>", $worklogt3);
$worklog = eregi_replace("[0-9]{10,10}",date("m/j/y g:i
a",$worklogt4),$worklogt4);
--

$worklogt1 is the value of the field from the database and the first two
replacements are actually for different characters, even though they
look the same.

Can anyone help me with this? I've been beating myself up for almost
three days over this.

Thanks in Advance,

Bob Palma
bpalma@ciber.net

[Back to original message]