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: beginners-unsubscr...@perl.org For additional commands, e-mail: beginners-h...@perl.org http://learn.perl.org/