Re: [PHP] Replacement Question.
On Wed, April 20, 2005 7:22 am, Bob Palma said: 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(,brbr, $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. Your problem is that you are passing in all of $worklogt4 to the date function, and that *BEGINS* with the first date/time, and that's what PHP uses. You need to FIRST break up your single line into separeate lines, based on the 10-digit time-stamps. Something like: $lines = split('[0-9]{10,10}', $worklogt4); But then I'm not sure you get to keep the date/time -- I never use split much, myself... -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Replacement Question.
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(,brbr, $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 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Replacement Question.
On Wednesday 20 April 2005 15:22, Bob Palma typed: 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 -- Are the group delimiters different from the field delimiters? Ie, can you do: $array_of_groups = explode('group_delim', $in_string); foreach ($array_of_groups as $i) { $array_of_fields = explode('field_delim', $i); $date = date('m/j/y g:i:a', $array_of_fields[0]); print $date {$a_o_f[1]}br /{$a_o_f[2]}br /br /\n; } YMMV of course. -- My mind not only wanders, it sometimes leaves completely. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Replacement Question.
Wow! Thanks.. That works great. Just one small hitch though. After it prints all of the data properly, it adds one more '$date' on the end which gets printed as '12/31/69 7:00:pm'. Is there a way to do all groups - 1 ? Bob Palma [EMAIL PROTECTED] Duncan Hill wrote: On Wednesday 20 April 2005 15:22, Bob Palma typed: 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 -- Are the group delimiters different from the field delimiters? Ie, can you do: $array_of_groups = explode('group_delim', $in_string); foreach ($array_of_groups as $i) { $array_of_fields = explode('field_delim', $i); $date = date('m/j/y g:i:a', $array_of_fields[0]); print $date {$a_o_f[1]}br /{$a_o_f[2]}br /br /\n; } YMMV of course. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Replacement Question.
On Wednesday 20 April 2005 16:01, Bob Palma typed: Wow! Thanks.. That works great. Just one small hitch though. After it prints all of the data properly, it adds one more '$date' on the end which gets printed as '12/31/69 7:00:pm'. Is there a way to do all groups - 1 ? No reason for it to do that unless your data is a bit weird. Use print_r() or var_dump to see what each array contains - you might find you have a blank entry being tacked on somehow (which you could detect with an if). -- My mind not only wanders, it sometimes leaves completely. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Replacement Question.
Thanks. I took a look, and you were right. It was creating another entry in the array at the end, so I used an if statement checking the value of [1] and [2] in $array_of_fields. Thanks for all the great help Bob Palma [EMAIL PROTECTED] Duncan Hill wrote: On Wednesday 20 April 2005 16:01, Bob Palma typed: Wow! Thanks.. That works great. Just one small hitch though. After it prints all of the data properly, it adds one more '$date' on the end which gets printed as '12/31/69 7:00:pm'. Is there a way to do all groups - 1 ? No reason for it to do that unless your data is a bit weird. Use print_r() or var_dump to see what each array contains - you might find you have a blank entry being tacked on somehow (which you could detect with an if). -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php