Formatting the column of a CSV file using perl

[gouse.aman]

Hi Monks, I have been working perl from a good time and now I have come across one problem. I have to read a CSV file and get the data and for few conditions I have to read the 2nd column data which has the time and write it into a text file. The data format seems something like "21:09.3" when open with excel file to see the value and prints the same way in my output file. Now when I open it with wordpad it shows the same value as "18:21:09.32". I can directly format the column in excel but that has to be done through the perl script itself. So please provide a quick answer soon. Help at the earliest needed. Thanks!

[marto]

A CSV file is plain text. Either write the data to the file exactly as you want it displayed or actually create an Excel file (Spreadsheet::WriteExcel) and apply whatever formatting you want.

[Anonymous Monk]

I can't help you, but examples/csv2xls might, good luck