How to explode date from a string using php preg_match and regex

Question

I am processing strings with a date somewhere in it. There are different ways the date can appear in this string:

"… 01.11.2009 18:00-21:00 …" or "… 01.11.2009 18:00-02.11.2009 15:00 …" or "… 01.11.2009 18:00 …"

Regardless how the date appears I only need the beginning date "01.11.2009 18:00". So if there are two matches it's just the first one. How can I isolate/explode this from the full string in php. any idea?

I guess I need to create a pattern with regex and then matching it with preg_match. Is this the way? Unfortunately I am not into regex very much. Could anyone help with getting my single date block from a random string?

Ben Regenspan · Accepted Answer · 2009-10-27 01:04:14Z

1

$matches = array();
$desired_date = '';
preg_match('/\d{2}\.\d{2}\.\d{4} \d{2}:\d{2}/', $string_containing_dates, $matches);
if (isset($matches[0])) $desired_date = $matches[0];

answered Oct 27, 2009 at 1:04

Ben Regenspan

10.6k2 gold badges35 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

cletus · Accepted Answer · 2009-10-27 01:01:12Z

0

Try:

$s = "… 01.11.2009 18:00-21:00 …… 01.11.2009 18:00-02.11.2009 15:00 …… 01.11.2009 18:00 …";
preg_match_all('!(\d{2}\.\d{2}\.\d{4}) \d{2}:\d{2}(-\d{2}:\d{2}|-\d{2}\.\d{2}\.\d{4} \d{2}:\d{2})?!', $s, $matches);
print_r($matches[1]);

answered Oct 27, 2009 at 1:01

cletus

627k169 gold badges922 silver badges945 bronze badges

Comments

Corey Ballou · Accepted Answer · 2009-10-27 01:02:08Z

0

if your date is formatted in the following manner you will always have the same number of characters for each date. You could then use a simple substr() to take the beginning X chars:

// example date strings
$date = date('m.d.Y h:i:S');
$date2 = date('m.d.Y h:i:S', strtotime('+50 days'));
$date_str = $date . '-' . $date2;

// get the first 10 characters for the date
$match = substr($date_str, 0, 10);

answered Oct 27, 2009 at 1:02

Corey Ballou

43.7k8 gold badges66 silver badges77 bronze badges

Comments

nickf · Accepted Answer · 2009-10-27 01:05:03Z

0

Try this one:

preg_match_all(
    '/([0-9]{2}\.[0-9]{2}\.[0-9]{4} [0-9]{2}:[0-9]{2})' // linebreak added
    . '(?:-(?:[0-9]{2}\.[0-9]{2}\.[0-9]{4} )?(?:[0-9]{2}:[0-9]{2})?)?/',
    '" 01.11.2009 18:00-21:00 " or " 01.12.2009 18:00-02.12.2009 15:00 " '
    . 'or " 01.01.2009 18:00 "',
    $matches
);

print_r($matches[1]);
// "01.11.2009", "01.12.2009", "01.01.2009"

answered Oct 27, 2009 at 1:05

nickf

548k199 gold badges660 silver badges727 bronze badges

Comments

Travis · Accepted Answer · 2009-10-27 01:06:52Z

0

You can extract the first date in that format using the function below:

function find_date($string) {
    preg_match("/\d{2}\.\d{2}\.\d{4} \d{2}:\d{2}/",$string,$matches);
    return $matches[0];
}

answered Oct 27, 2009 at 1:06

Travis

4,0887 gold badges40 silver badges52 bronze badges

Collectives™ on Stack Overflow

How to explode date from a string using php preg_match and regex

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related