asked on

want certain lines that match a pattern in a string

Ray Paseur

You can use explode(PHP_EOL) to isolate the lines, then use explode('|') to isolate the fields in each line. Then you can use strtotime() on position zero of the resulting array. If it returns anything other than FALSE, you've got one of the lines that begins with the DATETIME value.

rgb192

ASKER

I dont understand. I am not good with regular expressions

stalhw

$arrayS=preg_split("[\n|\r]",$string);

foreach ($arrayS as $line) {
if (preg_match("/([0-9\/]{10} [0-9:]{8}[AP]M)\s*|([^|]*)|\s|([^|]*)/",$line,$matched)) {
print "\nLine: $line\nMatched: ";
print_r($matched);
}
}

something like this should do it.

stalhw

hmm correction to the preg_match:

if (preg_match("/^([0-9\/]{10} [0-9:]{8}[AP]M)\s*\|([^\|]*)\|\s\|([^\|]*)/",$line,$matched)) {

rgb192

ASKER

there was no output

<?php
    
$string='
05/24/2011 04:55:42PM | dbquery |  | words words
line2
line3
another line
06/27/2011 05:58:40PM | dbquery |  | more words
';

$arrayS=preg_split("[\n|\r]",$string);

foreach ($arrayS as $line) {
//if (preg_match("/([0-9\/]{10} [0-9:]{8}[AP]M)\s*|([^|]*)|\s|([^|]*)/",$line,$matched)) {
if (preg_match("/^([0-9\/]{10} [0-9:]{8}[AP]M)\s*\|([^\|]*)\|\s\|([^\|]*)/",$line,$matched)) {

print "\nLine: $line\nMatched: ";
print_r($matched);


echo "\nLine: $line\nMatched: ";
echo($matched);

}
}

Open in new window

ASKER CERTIFIED SOLUTION

stalhw

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

rgb192

ASKER

thanks

Ray Paseur

No regular expressions are needed. I'll post a code sample in a moment.

Ray Paseur

<?php // RAY_temp_jd11b.php
error_reporting(E_ALL);
date_default_timezone_set('America/Chicago');



// TEST DATA FROM THE POST AT EE
$string='
05/24/2011 04:55:42PM | dbquery |  | words words
line2
line3
another line
06/27/2011 05:58:40PM | dbquery |  | more words
';



// SEPARATE THE LINES
$arr = explode(PHP_EOL, $string);
$out = array();
foreach ($arr as $line)
{
    // SEPARATE THE FIELDS IN THE LINE
    $new = explode('|', $line);

    // IF NOT A DATETIME, SKIP IT
    if (strtotime($new[0]) === FALSE) continue;
    $out[] = $line;
}

// RECONSTRUC THE STRING
$answer = implode(PHP_EOL, $out);

// SHOW THE WORK PRODUCT
echo "<pre>";
print_r($answer);

Open in new window