Re: file/array manipulation

["Mignon Hunter" <mignon.hunter@xxxxxxxxxxxxxxx>]

Ok I got this to work but I'm not sure how -- and am having trouble re-producing the data:

My script I have so far is:

$lines = file('test2.csv');
foreach ($lines as $line) {
	$line_split = explode(",", $line);
	if(!(empty($line_split[0]) ) ){
		//echo "I'm not empty";
		$new_array = array(
			$line_split[0] => $line_split[1]
			);	   
		}		
		print("<pre>");
		print_r($new_array);
		print("</pre>");		
		//echo "<tr><td>" . $new_array[0] . "</td><td>" . $new_array[1] . "</td></tr>";// this doesnt work			
}

Here's what the printed format spits out (abbreviated):

Array
(
    [R] => "ABC company
)
Array
(
    [R] => "ABC company
)
Array
(
    [R] => "ABC company
)
Array
(
    [R] => "ABC company
)
Array
(
    [O] => XYZ company
)
Array
(
    [O] => XYZ company
)
Array
(
    [O] => XYZ company
)
Array
(
    [O] => XYZ company
)

So - I'm getting the write letters assigned to write companys which is great. But my echo line:

echo "<tr><td>" . $new_array[0] . "</td><td>" . $new_array[1] . "</td></tr>";// this doesnt work	

Do I have several arrays or a multidim array?

Thanks for any guidance

>>> "Richard Lynch" <ceo@xxxxxxxxx> 03/15/05 10:39AM >>>

> Hello
>
> I'm trying to manipulate a text(.csv) file using php. I've read the file
> and can print each line,
>  but I need to write where column A is missing
>
> ColumnA    ColumnB
>
> R                ABC company
>                   ABC company
>                   ABC company
>                   ABC company
> O                XYZ company
>                    XYZ company
>                    XYZ company
>                    XYZ company
>
> What I need to do is write a while loop (I think) to interate through the
> lines and populate ColumnA
> while ColumnB equals $var (ABC company, XYZ company), so that I end up
> with:
>
> ColumnA    ColumnB
>
> R                ABC company
> R                ABC company
> R                ABC company
> R                ABC company
> O                XYZ company
> O                XYZ company
> O                XYZ company
> O                XYZ company
>
> Is this possible. What I've got so far to print out the file:
>
> $lines = file('test2.csv');
>

$category = '';

> // Loop through our array, and show line and numbers too.
> foreach ($lines as $line_num => $line) {
>   echo "Line #<b>{$line_num}</b> : " . $line . "<br />\n";

//Assuming it's the FIRST character of each line that has space or category:
//Check first character:
if ($line[0] != ' ' && $line[0] != "\t"){
  $category = $line[0];
}

echo "$category\t", trim(substr($line, 1)), "<br />\n";

> }
>
>
> Thanks in advance
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php 
>
>


-- 
Like Music?
http://l-i-e.com/artists.htm 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php