Regular expression for preg_split() by new line

Question

This is my file:

0.0 5.0 5.0 6.0 7.0 2.0 5.0 2.0 1.0 5.0 5.0 1.0 2.0 7.1 5.0
5.0 0.0 5.0 5.0 5.0 2.0 5.0 1.0 5.0 6.0 6.0 6.0 6.0 1.0 7.1
5.0 5.0 0.0 6.0 1.0 6.0 5.0 5.0 1.0 6.0 5.0 7.0 1.0 5.0 6.0
6.0 5.0 6.0 0.0 5.0 2.0 1.0 6.0 5.0 6.0 2.0 1.0 2.0 1.0 5.0
7.0 5.0 1.0 5.0 0.0 7.0 1.0 1.0 2.0 1.0 5.0 6.0 2.0 2.0 5.0
2.0 2.0 6.0 2.0 7.0 0.0 5.0 5.0 6.0 5.0 2.0 5.0 1.0 2.0 5.0
5.0 5.0 5.0 1.0 1.0 5.0 0.0 2.0 6.0 1.0 5.0 7.0 5.0 1.0 6.0
7.0 1.0 5.0 1.0 2.0 2.0 1.0 5.0 6.0 5.0 2.0 6.0 7.0 0.0 5.0
5.0 7.0 6.0 5.0 5.0 5.0 6.0 2.0 6.0 2.0 1.0 5.0 6.0 5.0 0.0

I would split it by \n and have returned in one array each row. How can I do the regular expression?

$rows = preg_split('$regular_expression', $content);

After I will extract all the rows, how can I extract each value separated by backspace?

$values_in_a_row = preg_split('$regular_expression', $a_row);

Here the text were I am trying to do it http://regexr.com?2v23c .

score 44 · Answer 1 · answered Apr 25 '16 at 21:20

44

If you are having issues because you don't know if each newline is just \n or \r\n or \r then none of the above answers work and a regexp works. What I did was

$lines = preg_split("/(\r\n|\n|\r)/",$content);

Then you can use the accepted answer to split the spaces.

answered Apr 25 '16 at 21:20

Bryan

3,449
1
19
23

5

`$lines = preg_split('~\R~',$content);` – Alex Skrypnyk May 30 '17 at 03:06
1

'~\R~' will break Chinese character 先 – John Wong Jan 05 '22 at 12:20

score 8 · Accepted Answer · edited Jul 06 '19 at 22:50

8

There isn't any need for regular expressions:

<?php
    $data = explode("\n", $data); // preg_split('#\n#', $data); Please don't
    foreach($data as &$row) {
        $row = explode(' ', $row); // preg_split('#\s#', $row); Seriously
    }
    print_r($data);
?>

<test></test>

edited Jul 06 '19 at 22:50

Peter Mortensen

30,738
21
105
131

answered Oct 28 '11 at 10:48

Tom

1,647
11
24

1

@MichaelKrelin-hacker OP shouldn't use regexp in that case – Tom Oct 28 '11 at 10:52
I wouldn't use regex, you wouldn't. But it's up to OP :) – Michael Krelin - hacker Oct 28 '11 at 10:56
@MichaelKrelin-hacker It's up to me to tell the OP what I think of his use of regexp and make this world a better place. – Tom Oct 28 '11 at 10:57
Tom, that's why I upvoted you, but you want to be not just right, but also impeccable. – Michael Krelin - hacker Oct 28 '11 at 11:00
1

@MichaelKrelin-hacker OP made me go FFFFUUUU, couldn't help it. Edited code's comments for impeccability. – Tom Oct 28 '11 at 11:02
@michele you don't need a regexp for a single character mask. The explode function is your friend in your case. – Tom Oct 28 '11 at 11:03
@michele, don't waste computing power, computers are people too. – Michael Krelin - hacker Oct 28 '11 at 11:06
@MichaelKrelin-hacker Now that's a shame. Going to meta right now. Wish I could upvote myself too. – Tom Oct 28 '11 at 11:09
So who consume less power? regexp or explode? – michele Oct 28 '11 at 12:09
Definetely explode ! Preg_split will bring your server's entire neighborhood down ! Talk about 2012 getting close. – Tom Oct 28 '11 at 12:16
ok, thanks but now i don't know who answer......each user take me a good and correct answer. – michele Oct 28 '11 at 13:00
4

The issue is, what if it isn't using the \n newline character? – Liam W Dec 29 '14 at 15:16
@LiamW Exactly the problem I was having. See my answer – Bryan Apr 25 '16 at 21:15
10

This does not answer the question. Not all strings use `\n` for newlines. – Abhi Beckert Sep 12 '16 at 02:48
it may be overpowered to use a regex, but it is not wrong. your answer might be working in this special case, but i voted down because of three things: 1) it is not even partially an answer to OPs question, 2) you did not explain WHY regular expressions are not the best idea in this case and 3) you didn't even bother to think about the feedback you already got and cared to edit your answer – DesertEagle Jan 11 '18 at 11:40

score 6 · Answer 3 · answered Oct 28 '11 at 10:48

6

$rowsapart = preg_split("/\n/",$rowstogether);

$colspart = preg_split("/\s/",$colstogether);

answered Oct 28 '11 at 10:48

Michael Krelin - hacker

138,757
24
193
173

I tested. The link doesn't open well for me, but I'd assume it uses different flavor of regex. – Michael Krelin - hacker Oct 28 '11 at 10:52
The problem with this code-only answer is that the OP and researchers may not understand how to set up this technique. In other words, they might not know how to declare `$rowstogether` and `$colstogether`. – mickmackusa Jul 25 '21 at 22:56

score 2 · Answer 4 · answered Oct 28 '11 at 10:50

No need for REGEX, use explode() instead:

<?php

    $file = <<<EOF
    0.0 5.0 5.0 6.0 7.0 2.0 5.0 2.0 1.0 5.0 5.0 1.0 2.0 7.1 5.0
    5.0 0.0 5.0 5.0 5.0 2.0 5.0 1.0 5.0 6.0 6.0 6.0 6.0 1.0 7.1
    5.0 5.0 0.0 6.0 1.0 6.0 5.0 5.0 1.0 6.0 5.0 7.0 1.0 5.0 6.0
    6.0 5.0 6.0 0.0 5.0 2.0 1.0 6.0 5.0 6.0 2.0 1.0 2.0 1.0 5.0
    7.0 5.0 1.0 5.0 0.0 7.0 1.0 1.0 2.0 1.0 5.0 6.0 2.0 2.0 5.0
    2.0 2.0 6.0 2.0 7.0 0.0 5.0 5.0 6.0 5.0 2.0 5.0 1.0 2.0 5.0
    5.0 5.0 5.0 1.0 1.0 5.0 0.0 2.0 6.0 1.0 5.0 7.0 5.0 1.0 6.0
    7.0 1.0 5.0 1.0 2.0 2.0 1.0 5.0 6.0 5.0 2.0 6.0 7.0 0.0 5.0
    5.0 7.0 6.0 5.0 5.0 5.0 6.0 2.0 6.0 2.0 1.0 5.0 6.0 5.0 0.0
    EOF;

    $rows = explode("\n", $file);
    print_r($rows);
    echo "\n\n"; //Spacing

    $numbers_in_a_row = explode(" ", $rows[0]);
    print_r($numbers_in_a_row);

?>

Live Example

score 1 · Answer 5 · answered Jul 25 '21 at 20:35

1

preg_split("/\R/", $content);

It is the most reliable way to split text by new lines if you are sure that incoming content has Unicode format.

/\R/ Matches any Unicode newline sequence that is in the ASCII range. it is equivalent to

/(?>\r\n|\n|\r|\f|\x0b|\x85)/

answered Jul 25 '21 at 20:35

sprutex

980
12
12

This does not split the rows apart. You are only solving half of the question. – mickmackusa Jul 25 '21 at 22:50

Regular expression for preg_split() by new line

5 Answers5

Linked