|
|
Posted by Mignon Hunter on 03/16/05 22:55
Got it - never mind
instead of
$new_array = array($line_split[0] => $line_split[1] );
it's
$new_array = array($line_split[0] , $line_split[1] );
But I'm still not sure how it works so well...
************************
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@l-i-e.com> 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
Navigation:
[Reply to this message]
|