#!/usr/bin/perl -w
use strict;
use diagnostics;
use Text::ParseWords;

my $csvfilename = "data.csv";
open( FILE, "<", $csvfilename" )
  or die("Couldn't open CSV file $csvfilename:$!\n");

while ( my $line = <FILE> ) 
{
    my @fields = quotewords( ',', 0, $line ); #no & before 
                                              #quotewords() needed!
    
    my ($id,$brand,) = (@fields)[0,1];

    print "$id\t$brand\n";
}