vijay wrote:
> I need to consolidate columns of data available across different
> directories into a single excel csv file. Usually we write to a file
> row after row but for the current task I have, it would be convenient
> to write the file column after column. Is there a file writing mode
> for this?
> If not, I guess, I will have to write the matrix row by row and then
> take a transpose. Let me know what you guys think and if you could
> share some skeleton of code for something like this would be great.
Perl is very capable of doing what you need. Off the top of my head,
the p-code outline would be:
declare a two-dimensional array
iterate over columns
read data from a source and fill a column
iterate over rows
write a row of data to csv output file
If you're serious about learning Perl, you should get "Learning Perl":
http://oreilly.com/catalog/9780596520106/index.html
Perl works on a great many platforms, but there can be O/S-dependent
idiosyncrasies; I prefer a Linux. On Windows, I use Cygwin.
HTH,
David
--
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
http://learn.perl.org/
