[milknpepper]

Been stuck on this for over 2 hours - pls assist:

End goal: To turn contents of every txt file in my directory into a table.

So I have .txt files with contents like:

Giraffe: 1
Banana: 2
Monkey: 3

From each txt file I want it take out the "1" "2" and "3" and put it into columns (so I can later just paste it into excel and its already splitted).

I was able to achieve this for ONE file at a time using the script below:

PHP Code


<?php 
<body>


<?php
$lines = file('alskdgj.txt'); //here's the filename

?>
<table width=800>
<?php
foreach ($lines as $line) {
list($a,$b) = explode(':', $line);
print "<td width=40>$b</td>";
}
?>
</table>

</body> 


That is for alskdgj.txt, works perfect. But is it possible to do a forreach argument in the script so that it scans the directory and does this function for EVERY txt file in that directory ?

So that if I have 5 files, it would eventually give me a table with the values from the 5 txt files - rather doing each one by one.

Plz help. 🤝

[Anxuein]

You can use something like this to iterate:

PHP Code


<?php 
foreach(glob("*.txt") as $filename) {
    $lines = file($filename);
    // do splitting here
} 


[milknpepper]

thx will try now

---

You can use something like this to iterate:

PHP Code


<?php 
foreach(glob("*.txt") as $filename) {
    $lines = file($filename);
    // do splitting here
} 


Here is my code:

PHP Code


<?php 
<body>



<table width=800>
<?php
foreach(glob("folda/*.txt") as $filename) {
    $lines = file($filename);
        foreach ($lines as $line) {
        list($a,$b) = explode(':', $line);
        print "<td width=40>$b</td>";
}
} 


?>
</table>

</body> 


It does good for the first txt in the directory, but displays error:

Notice: Undefined offset: 1 in C:\xampp\htdocs\tabled\444.php on line 17

Notice: Undefined offset: 1 in C:\xampp\htdocs\tabled\444.php on line 17

Notice: Undefined offset: 1 in C:\xampp\htdocs\tabled\444.php on line 17

Notice: Undefined offset: 1 in C:\xampp\htdocs\tabled\444.php on line 17

Notice: Undefined offset: 1 in C:\xampp\htdocs\tabled\444.php on line 17

Notice: Undefined offset: 1 in C:\xampp\htdocs\tabled\444.php on line 17

Notice: Undefined offset: 1 in C:\xampp\htdocs\tabled\444.php on line 17

Notice: Undefined offset: 1 in C:\xampp\htdocs\tabled\444.php on line 17

1 2 3

[Anxuein]

Can you provide the contents of the first file in directory and second?

[milknpepper]

Can you provide the contents of the first file in directory and second?

wierd. restarted browser now it shows all 3. but still has the errors on top.

Contents of files:
first one:

Giraffe: 1
Banana: 2
Monkey: 3

second one:

Giraffe: 12
Banana: 21
Monkey: 53

third one

Giraffe: 12
Banana: 24
Monkey: 223

And this is what I'm seeing in the browser:

Notice: Undefined offset: 1 in C:\xampp\htdocs\tabled\444.php on line 17

Notice: Undefined offset: 1 in C:\xampp\htdocs\tabled\444.php on line 17

Notice: Undefined offset: 1 in C:\xampp\htdocs\tabled\444.php on line 17

1   2   3                 12   21   53                 12   24   223

[Anxuein]

Try this my dude:

PHP Code


<?php 
<body>



<table width="800">
<?php
foreach(glob("folda/*.txt") as $filename) {
    $lines = file($filename);
    foreach ($lines as $line) {
        $split = explode(': ', $line);
        if (isset($split[1])) {
            echo "<td width=\"80\">$split[1]</td>";
        }
    }
}


?>
</table>

</body> 


[milknpepper]

Try this my dude:

PHP Code


<?php 
<body>



<table width="800">
<?php
foreach(glob("folda/*.txt") as $filename) {
    $lines = file($filename);
    foreach ($lines as $line) {
        $split = explode(': ', $line);
        if (isset($split[1])) {
            echo "<td width=\"80\">$split[1]</td>";
        }
    }
}


?>
</table>

</body> 


Almost perfect bro!
It's returning me a table of 9 columns. No errors tho.
Is it possible to make it 3 x 3 rather?
That is; so that every txt file has its own row?

[Anxuein]

PHP Code


<?php 
<body>



<table width="800">
<?php
foreach(glob("folda/*.txt") as $filename) {
    $values = [];
    $lines = file($filename);
    foreach ($lines as $line) {
        $split = explode(': ', $line);
        if (isset($split[1])) {
            $values[] = $split[1];
        }
    }

    // just to make sure we don't try to output an empty row
    if (!empty($values)) {
        echo "<tr>";
        foreach ($values as $v) {
            echo "<td width=\"80\">$v</td>";
        }
        echo "</tr>";
    }
}


?>
</table>

</body> 


[milknpepper]

PHP Code


<?php 
<body>



<table width="800">
<?php
foreach(glob("folda/*.txt") as $filename) {
    $values = [];
    $lines = file($filename);
    foreach ($lines as $line) {
        $split = explode(': ', $line);
        if (isset($split[1])) {
            $values[] = $split[1];
        }
    }

    // just to make sure we don't try to output an empty row
    if (!empty($values)) {
        echo "<tr>";
        foreach ($values as $v) {
            echo "<td width=\"80\">$v</td>";
        }
        echo "</tr>";
    }
}


?>
</table>

</body> 


🤗 YOU THE BEST!!!

---

@Anxuein

I'm trying to PM you but its not letting me.
You really know what you're doing in php (unlike me). If you have time, would you be interested in doing a php project for btc?
Its really short and simple - and this script was probably 40% of it.

If ya, pls pm me.

[AppleJuice]

OP, if you want to import data stored in a text file into Excel, it'd probably be easier to just parse your data and save it as CSV format (columns separated by commas) and then load it normally into Excel.