cropping data

Anon

hi,

I am trying to do two things:

1- open a remote CSV file, then...
2- grab say the 3rd comma seperated value from each line and pass to an array.

help please 🙂
Giv

brandonschnell

file() may also work depending on what you need to do. i just wrote the below yesterday as i had a binary file with lines terminated with CR chars and values seperated by tabs. you may need to modify it a bit depending on the type of file you're trying to read.

$array = array();

$fp = fopen("$remote_file","r");
$data = fread($fp, filesize("$userfile"));
fclose($fp);

$line = split("\n",$data);
while($row = each($line))
{
$elements = split(",",$row[1]);
array_push ($array, $elements[2]);
}

Anon

try this:

<?PHP

Declare filename

$filename = "logtest.txt";

Open File

if(!($fp = fopen("$filename", "r"))) die ("Cannot open the file");

Pass file data to variable

$data = fread($fp, filesize($filename));
fclose($fp);

Split lines into arrays

$line = split("\n",$data);

$arraycount = 0;

Loop through every line

while ($arraycount < count($line))

{
# Split commas on each line into arrays
$array = explode(",", $line[$arraycount]);

# Print 7th array value
echo "<BR>$array[7]";

# Move to next line
$arraycount = $arraycount + 1;
}