Hi, Thanks for the tip, will try to figure it out on the weekend and come back if I'm stuck.
Just a few questions before I try this... Does these modules have the ability to add the commas in the way I need them to be? The CVS_XS.pm module seems more flexible/powerful than the CVS.pm one or am I wrong? Regards, Wernher On 24 June 2011 10:19, Dermot <paik...@googlemail.com> wrote: > On 24 June 2011 08:45, Wernher Eksteen <wekst...@gmail.com> wrote: > > Hi, > > > > I've attached a text file containing the original and required format and > > avoid the format > > being lost by just pasting it in the email body. > > > > The original format is separated by a space, but need to replace the > space > > with a comma, > > so it will become a comma delimited csv file which I will then import to > MS > > Excel. > > > > I'm not sure how to parse the "Connection" and "Sync'ed-as-of-time" > columns > > since the dates > > there in is in this format "Fri Jun 24 06:37" which also separated by > space, > > but the spaces in > > those columns shouldn't be replaced by a comma. The date format in those > > columns should > > remain the same. > > > > Also, is it possible to convert this directly into a MS Excel document > using > > Perl? > > Yes, you can achieve all your goals with perl. Have a look and > Text::CSV_XS[1] or Text::CSV[2]. They will read the file correctly and > write the file out for you with any separator you want. BTW, you want > quotes around each field so as not to confuse you spreadsheet program. > Writing the file into XLS format would require another module but I'll > leave others to make that recommendation. > > Perhaps you could have a look at those, try and write something and > when, or if, you get stuck, come back to the list showing the code > you've got and get some pointers. > > Thanks, > Dermot. > > > 1) http://search.cpan.org/~hmbrand/Text-CSV_XS-0.82/CSV_XS.pm > 2) http://search.cpan.org/~makamaka/Text-CSV-1.21/lib/Text/CSV.pm > > -- > To unsubscribe, e-mail: beginners-unsubscr...@perl.org > For additional commands, e-mail: beginners-h...@perl.org > http://learn.perl.org/ > > >
