Parse a File

I have a directory with aproximately 3000 txt files in it. Each txt file has a one line of text something like this.

File name 12345.txt

12345 Some Description $9.99

I need to pull everything between the item number and the $ and input that value into my database.

So the steps would be:

get list of files in directory

open filename
get text between itemnumber and $
write to database
close file

repeat for each file

the itemnumber is the same as the file name minus the .txt extention.

I would appreciate any help.

Gary

well this is just off the top of my head but

// Connect and select to database

OPEN MYSQL STUFF

$dp = opendir("/path/to/directory");

while (($file = readdir($dp))!==false) {

$fp = fopen($file,"r");

$line = fgets($fp, 500);

$array = explode(" ", $line);

fclose($fp);

MYSQL_QUERY("Insert into Table values($array[0], $array[1],$array[2],$array[3]));

}// end while

// Then you would close the database and stuff here
CLOSE DATABASE AND DO EXITING STUFF

Thats the best I can do on short notice 🙂. I hope that this helps....

$array = explode(" ", $line);

This will not get just the data between the item number and the $ though. That is my biggest problem 🙂

Like this?
12345 Some Description $9.99

becomes

Some Description

Then explode() will work, just use the oneth element.

$array = explode(' ', $line);
// $array[1] now contains description.

It does get rid of the spaces though. But since you already know they are spaces, just append them, e.g.

$array[1] = ' ' . $array[1] . ' ';

Diego