PHP , explode data from file

Question

I encountered a problem during exploding data from file. My file looks like

04-21-1991 9:09 58 10004-21-1991 9:09 33 00904-21-1991 9:09 34 01304-21-1991 17:08 62 11904-21-1991 17:08 33 00704-21-1991

I'd like to explode data from it like

04-21-1991 9:09 58 100

04-21-1991 9:09 33 009

04-21-1991 9:09 34 013

04-21-1991 17:08 62 119

04-21-1991 17:08 33 007

what i did till now is obtaining an array ( numbers are different, becouse file is different, but structure is the same)

    array(1) {
  [0]=>
  array(901) {
    [0]=>
    string(10) "07-21-1990"
    [1]=>
    string(5) "06:43"
    [2]=>
    string(2) "58"
    [3]=>
    string(14) "202
07-21-1990"
    [4]=>
    string(5) "07:03"
    [5]=>
    string(2) "33"
    [6]=>
    string(12) "4
07-21-1990"

and here is my code

header("Content-type:text/plain");
  $file = fopen("data/data-03", "r");

$result = array();
    $file = explode("   ", file_get_contents("data/data-03"));
    foreach ( $file as $content ) 
        {
            $result[] = array_filter(array_map("trim", explode("    ", $content)));
        }
    var_dump($result);

use str_split() instead of explode() if each element should be the same size — Mark Baker
– Mark Baker, Commented Dec 29, 2013 at 13:55
Explode by " " and then iterate the result and assign the values to your array — Itay Gal
– Itay Gal, Commented Dec 29, 2013 at 13:55
pay more attention to bring clear input and clear output, corresponding, well indented etc. This is horrible. — Tomas
– Tomas, Commented Dec 29, 2013 at 13:55
For structural assertion, grouping by that, and if your input contains varied spacing you may wish to use preg_match_all instead of a crude explode. — mario
– mario, Commented Dec 29, 2013 at 13:57

Bryan Elliott · Accepted Answer · 2013-12-29 14:32:27Z

2

You might want to try using preg_match_all(). Like so:

<?php
$string = "04-21-1991 9:09 58 10004-21-1991 9:09 33 00904-21-1991 9:09 34 01304-21-1991 17:08 62 11904-21-1991 17:08 33 00704-21-1991";

preg_match_all("/([\d]{2}-[\d]{2}-[\d]{4}\s[\d]*:[\d]{2}\s[\d]{2}\s[\d]{3})/", $string, $matches);

print_r($matches);

?>

The above code will output:

Array ( [0] => 04-21-1991 9:09 58 100 [1] => 04-21-1991 9:09 33 009 [2] => 04-21-1991 9:09 34 013 [3] => 04-21-1991 17:08 62 119 [4] => 04-21-1991 17:08 33 007 )

edited Dec 29, 2013 at 14:32

answered Dec 29, 2013 at 14:14

Bryan Elliott

4,0852 gold badges24 silver badges24 bronze badges

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

Comments

Itay Gal · Accepted Answer · 2013-12-29 14:20:05Z

0

Here's a simple code of doing that, assuming your initial data format won't change.

$str = "04-21-1991 9:09 58 100 04-21-1991 9:09 33 009 04-21-1991 9:09 34 013 04-21-1991    17:08 62 119 04-21-1991 17:08 33 007 04-21-1991";

$result = array();
$result = explode(" ",$str);
$row = 0;

for ($i = 0; $i < sizeof($result)-1; ){
    $arr[$row]["date"] = $result[$i++];
    $arr[$row]["hour"] = $result[$i++];
    $arr[$row]["num"] = $result[$i++];
    $arr[$row]["num2"] = $result[$i++];
    $row++;
}

//check some data:
for ($i = 0; $i < 3; $i++ ){
    echo $arr[$i]["date"] . " ";
    echo $arr[$i]["hour"] . " ";
    echo $arr[$i]["num"] . " ";
    echo $arr[$i]["num2"] . " ";
    echo "<br />";
}

edited Dec 29, 2013 at 14:20

answered Dec 29, 2013 at 14:14

Itay Gal

10.8k6 gold badges43 silver badges78 bronze badges

Comments

cytofu · Accepted Answer · 2013-12-29 14:27:15Z

0

you could also process the exploded array in the following way:

$out = array();

for ( $i=0; $i<count($result); $i++){
    if ( floor($i / 4) == ($i / 4))
        $out[ floor($i / 4) ] = $result[$i];
    $out[ floor($i / 4) ] .= ' '.$result[$i]; 
}

you could replace ' ' with the seperator you want, I assumed a simple space.

It is basicly always concatenating 4 entries of the array resulting from your explosion, and adds them to a new array. You could also fetch the results in a new String and just add a \n after every 4th entry in the same way, if that is what you desire.

edited Dec 29, 2013 at 14:27

answered Dec 29, 2013 at 14:20

cytofu

9039 silver badges17 bronze badges

1 Comment

Kordian Wikliński Over a year ago

All answers are very handfull, but Your the most. Thank You

Collectives™ on Stack Overflow

PHP , explode data from file

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related