Solved

remove hours if hours=0

Posted on 2013-06-26
7
193 Views
Last Modified: 2013-07-01
input from excel file
0:00:02
0:50:04
0:04:08
1:20:30
0:00:09

remove
hours and :
if hours = 0

want output:
00:02
50:04
04:08
1:20:30
00:09
0
Comment
Question by:rgb192
7 Comments
 
LVL 9

Accepted Solution

by:
TvMpt earned 500 total points
ID: 39277348
echo preg_replace('/(^(0:))/m',' ',$sourcestring);

Open in new window

0
 
LVL 11

Expert Comment

by:mcnute
ID: 39277350
you could do,

if date('H', time()) == 0 
echo date('H:i', time());

Open in new window

0
 
LVL 4

Expert Comment

by:ramyajanarthanan
ID: 39277418
I hope you import files to your db from the excel sheets.Please may i know your requirement clearly.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 6

Expert Comment

by:Robert Saylor
ID: 39277715
It's best to convert the time to seconds then use a math equation to see if it is over 59 mins in seconds. Then you could use an else to display the H or not.
0
 
LVL 108

Expert Comment

by:Ray Paseur
ID: 39278296
The standard methods of handling date and time values are given in this article.  Se the parts about Time Without Date and Practical Application #3.
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_201-Handling-date-and-time-in-PHP-and-MySQL.html

With the test data posted here, I think TvMpt has an accurate solution.  But I think my instincts would lead me to keep the hours, even if they are zero.
0
 

Author Closing Comment

by:rgb192
ID: 39290861
i did not understand the time() command (where to put variable)

so this preg_replace worked

thanks
0
 
LVL 108

Expert Comment

by:Ray Paseur
ID: 39290903
You do not need to understand the time() command.  The time() command is not the right tool to use.  This article explains the way to do date and time format conversions.
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_201-Handling-date-and-time-in-PHP-and-MySQL.html

The quality of test data is usually more important than the programming.  You might want to run this to see what output you will get.

<?php // RAY_temp_rgb192.php
error_reporting(E_ALL);
echo '<pre>';

// TEST DATA WITH AN OUTLIER
$arr = array
( '0:00:02'
, '0:50:04'
, '0:04:08'
, '1:20:30'
, '0:00:09'
, '00:00:09'
)
;

// TRY THE REGEX
foreach ($arr as $sourcestring)
{
    echo PHP_EOL;
    echo $sourcestring;
    echo ' => ';
    echo preg_replace('/(^(0:))/m',' ',$sourcestring);
}

Open in new window

0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
php ssh2_scp_send 1 46
php email 2 24
Download a website to hdd 2 47
PHP: concatenate query 12 28
This article will explain how to display the first page of your Microsoft Word documents (e.g. .doc, .docx, etc...) as images in a web page programatically. I have scoured the web on a way to do this unsuccessfully. The goal is to produce something …
Generating table dynamically is the most common issue faced by php developers.... So it seems there is a need of an article that explains the basic concept of generating tables dynamically. It just requires a basic knowledge of html and little maths…
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now