"I have seen csv::text cpan , but it does not talk about extraction of any column as individual"

Yes it does! You couldn't have read very far: it's in the first few lines of Text::CSV SYNOPSIS:

    $row->[2] ... # 3rd field ...
[download]