How can I tokenize a string and parse it into an array and read them

Question

So, I want my page to read a txt file and then, tokenize it and create variables like an array.

For example:

My txt file:

Column1/Column2/Column3
A:K:Z
B:U:D

and then I want to read it like $variable['0']['Column1'];

Is there any way to do it?

<?php
    $handle = @fopen("info.txt", "r");
    if ($handle) {
        while (($buffer = fgets($handle, 4096)) !== false) {

            $delimiters = ":";

            $token = strtok($buffer, $delimiters);
            $result = [];
            $row = [];
            $columns = ['rede', 'servidor', 'data', 'hora', 'usuarios', 'servidores'];
            while ($token){
                $row[$columns[count($row)]] = $token;
                if (count($row) == 6) { // write record
                    $result[] = $row;
                    $row = [];
                }
                $token = str_replace('\r', '', strtok($delimiters));
            }
            print_r($result);
        }
        if (!feof($handle)) {
            echo "Error: unexpected fgets() fail\n";
        }
        fclose($handle);
    }
?>

Are the column headers defined in the text document? Is that what the "Column1/Column2/Column3" is? Or are they defined in your code in $columns? — Don't Panic
– Don't Panic, Commented Jan 8, 2019 at 22:58
This was just an example. Because this code I tried to, but I couldn't reach what I want. — user3388243
– user3388243, Commented Jan 8, 2019 at 23:00
We'd need to know the exact format specs in order to figure out edge cases. For instance, how does it escape literal / and :characters? Or, can you expect headers in the middle of the file? — Álvaro González
– Álvaro González, Commented Jan 9, 2019 at 7:48

Don't Panic · Accepted Answer · 2019-01-08 23:02:50Z

1

I wouldn't use strtok. I think it would be easier to just use : as the delimiter in fgetcsv. Something like this:

if ($handle) {
    $columns = ['rede', 'servidor', 'data', 'hora', 'usuarios', 'servidores'];
    while (($row = fgetcsv($handle, 0, ':')) !== false) {
        if (isset($row[5])) {
            $result[] = array_combine($columns, $row);
        }
    }
}

answered Jan 8, 2019 at 23:02

Don't Panic

41.9k11 gold badges70 silver badges87 bronze badges

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

7 Comments

user3388243 Over a year ago

How could I get a value from the first line from column "servidor"?

Don't Panic Over a year ago

Should be $result[0]['servidor']

user3388243 Over a year ago

It didn't work, actually, it creates an empty array.

user3388243 Over a year ago

<?php $handle = @fopen("info.txt", "r"); if ($handle) {     $columns = ['rede', 'servidor', 'data', 'hora', 'usuarios', 'servidores'];     while (($row = fgetcsv($handle, 0, ':')) !== false) {         if (isset($row[5])) {             $result[] = array_combine($columns, $row);         }     } }  echo $result;  ?>

user3388243 Over a year ago

sVipCHAT:IRC.jacksoow.Net:08/01/2019:19:24:51:499:80 sVipCHAT:IRC.NeoStats.Org:08/01/2019:19:25:49:500:80

|

Collectives™ on Stack Overflow

How can I tokenize a string and parse it into an array and read them

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related