|
|
Posted by Richard Lynch on 03/15/05 18:39
> 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]
|