Depending on what you really need to do and how big the task is it may be worth converting the csv file to a database, or at least using DBD::AnyData along with DBI to wrap your csv file up as though it were a database. Column manipulations then become rather straight forward.