JSON split using preg_split in PHP

Question

I have different servers

$strarrServerIp = array('192.168.123.1','192.168.123.2');
$strarrLogsData = array();
foreach($strarrServerIp as $strServerIp ){
       $strCommand = 'ssh abose@' . $strServerIp . ' cat /srv/www/vhosts/trunk/Logs/Log20130825.psi.log';
        $strarrLogsData[] = shell_exec( $strCommand );

            }
foreach( $strarrLogsData as $strJsonLogData ){
           foreach( preg_split("/((\r?\n)|(\r\n?))/", $strJsonLogData ) as $strJsonLineLog ) {
                                display($strJsonLineLog);
                        }
                }

The servers contain files containing JSON logs in this form.

 {"timestamp":"2013-08-25 20:35:06 MDT","severity":"INFO","data":"1"}
 {"timestamp":"2013-08-25 20:36:06 MDT","severity":"INFO","data":"15"}
 {"timestamp":"2013-08-25 20:37:06 MDT","severity":"INFO","data":"32"}
 {"timestamp":"2013-08-25 20:38:06 MDT","severity":"INFO","data":"25"}
 {"timestamp":"2013-08-25 20:39:06 MDT","severity":"INFO","data":"5"}

I want to separate them into an array

array (
    [0] => {"timestamp":"2013-08-25 20:35:06 MDT","severity":"INFO","data":"1"}
    [1] => {"timestamp":"2013-08-25 20:36:06 MDT","severity":"INFO","data":"15"}
    [2] => {"timestamp":"2013-08-25 20:37:06 MDT","severity":"INFO","data":"32"}
    [3] => {"timestamp":"2013-08-25 20:38:06 MDT","severity":"INFO","data":"25"}
    [4] => {"timestamp":"2013-08-25 20:39:06 MDT","severity":"INFO","data":"5"}
)

Any suggestions? I want something better than

 preg_split("/((\r?\n)|(\r\n?))/", $strJsonLogData )

Do you expect to have many rows in that file? Maybe you're better off with reading one line at a time. Or you could just explode on newline. — JimL
– JimL, Commented Sep 9, 2013 at 5:51

user1646111 · Accepted Answer · 2013-09-09 05:58:55Z

1

Try this, you can also use file() function to get each line separated in an array.

$text = '
 {"timestamp":"2013-08-25 20:35:06 MDT","severity":"INFO","data":"1"} {"timestamp":"2013-08-25 20:36:06 MDT","severity":"INFO","data":"15"}
 {"timestamp":"2013-08-25 20:37:06 MDT","severity":"INFO","data":"32"}
 {"timestamp":"2013-08-25 20:38:06 MDT","severity":"INFO","data":"25"}
 {"timestamp":"2013-08-25 20:39:06 MDT","severity":"INFO","data":"5"}';

$array =  preg_split("#}.*?{#s", $text );

$array = array_map("trim", $array);
print_r($array);


//using preg_match_all

preg_match_all("#({.*?})#s", $text, $matches);
print_r($matches[1]);

answered Sep 9, 2013 at 5:58

user1646111

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

Comments

Tzach · Accepted Answer · 2013-09-09 05:47:48Z

0

Split by \n and use json_decode on each line.

answered Sep 9, 2013 at 5:47

Tzach

13.4k15 gold badges77 silver badges117 bronze badges

1 Comment

Abhishek Over a year ago

preg_split("/((\r?\n)|(\r\n?))/", $strJsonLogData ) already does that . I want a custom function which will separate even if they are on the same line.

Collectives™ on Stack Overflow

JSON split using preg_split in PHP

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related