Split a log file using preg_split based on dates with PHP?

Question

I have a txt file with this format:

14/12/2020 12:02:50
LOG_HERE_1 XXXXX

14/12/2020 12:04:55
LOG_HERE_2 XXXXX

14/12/2020 12:10:33
LOG_HERE_3 XXXXX

And I need to parse it, using a regexp on the dates (dd/mm/yyyy hh:mm:ss), but keeping the date on the array. For example:

Array(
 [0] => '14/12/2020 12:02:50 LOG_HERE_1 XXXXX',
 [1] => '14/12/2020 12:02:50 LOG_HERE_2 XXXXX',
 [2] => '14/12/2020 12:02:50 LOG_HERE_3 XXXXX'
)

I tried this:

$array = preg_split('/(\d{2}\/\d{2}\/\d{4}\s\d{2}[:]\d{2}[:]\d{2})/', $data, null, PREG_SPLIT_DELIM_CAPTURE);

but it shows me:

{
 0: "",
 1: "14/12/2020 12:02:50",
 2: "",
 3: "14/12/2020 12:04:55",
 4: "",
 5: "14/12/2020 12:10:33",
 6: ""
}

The fourth bird · Accepted Answer · 2021-03-09 08:48:00Z

1

Using the flag PREG_SPLIT_DELIM_CAPTURE you can also match the lines that start with a date time like format followed by all lines that do not start with one using a negative lookahead (?!

^(\d{2}/\d{2}/\d{4}\h\d{2}:\d{2}:\d{2}\b.*\R(?:(?!\d{2}/\d{2}/\d{4}\h\d{2}:\d{2}:\d{2}\b).*\R?)*)

If starting with a date like pattern would also suffice, you could shorten it to:

^(\d{2}/\d{2}/\d{4}\b.*\R(?:(?!\d{2}/\d{2}/\d{4}\b).*\R?)*)

See a regex demo

For example

$pattern = "~^(\d{2}/\d{2}/\d{4}\h\d{2}:\d{2}:\d{2}\b.*\R(?:(?!\d{2}/\d{2}/\d{4}\h\d{2}:\d{2}:\d{2}\b).*\R?)*)~m";    
$result = preg_split($pattern, $data, -1, PREG_SPLIT_DELIM_CAPTURE | PREG_SPLIT_NO_EMPTY);
print_r($result);

See a php demo or with the log on the same line.

Output

Array
(
    [0] => 14/12/2020 12:02:50
LOG_HERE_1 XXXXX


    [1] => 14/12/2020 12:04:55
LOG_HERE_2 XXXXX


    [2] => 14/12/2020 12:10:33
LOG_HERE_3 XXXXX
)

Note that the date like pattern does not validate a date itself.

answered Mar 9, 2021 at 8:48

The fourth bird

165k16 gold badges61 silver badges75 bronze badges

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

3 Comments

Nicolas Manzanos Over a year ago

I tried this solution, , but the lines behind the date, does not show, it returns me just the dates without logs text

The fourth bird Over a year ago

@NicolasManzanos Is the structure of the example log the same as the real log? Are there spaces before the date? regex101.com/r/238aVg/1 Are you reading the whole file at once? What is the output of var_dump($data); ?

Nicolas Manzanos Over a year ago

I noticed that the dates in my log had a tabulation instead of space in the middle, now its fixed!, thanks you

Collectives™ on Stack Overflow

Split a log file using preg_split based on dates with PHP?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related