Hello "use Perl" World! My name is Eyi, and I'm trying to learn Perl. I first started learning programming a year ago, and I learnt C++. Last Summer, I had to do my project in C# so I ended up learning that too.
So I thought, I know C++ and C#, I'm good to go! Now I have to learn Perl.
It's been pretty straighforward so far, and for that I'm grateful. But I've been stuck in a rut for two days and I need help!
I've been using a book, "Perl: Your Visual BluePrint for Building Perl Scripts" and I think it is a good book. I ordered another book online but it hasnt come yet.
Basically, my challenge right now is to find a way of
* reading in the data in a particular column of the sheets of an excel file
* searching through two lists of names for close matches, not exact matches.
So if anyone happens to come by here and see this, and you have an answer, please please leave me a comment and I'd really really appreciate it!
Thank you!
The "use Perl;" site isn't the best place to get this kind of question answered; the journal system is used more for blog-type posts by individual users.
The FAQ for this site sorta tells you that but doesn't have a link to places where you can get answers to your kind of question.
What's this site for?
Thanks for asking. This site is intended (for now) to be a site where the Perl user community can get information about and discuss the latest news and issues related to Perl. This site is not (for now:)
First, let me recommend you direct Perl related questions to PerlMonks http://perlmonks.org/ [perlmonks.org] as that is the primary focus of that community
To give some pointers to the actual question at hand, a little more information is needed. Are you reading actual Excel files or do you have the option of reading a "save as" CSV?
If the former - consider Win32::OLE or Spreadsheet::ParseExcel
If the latter - consider Text::xSV (several more options are available, just search for CSV)
Hi L~R,
I'm checking out PerlMonks.org..
About d Excel, It's the former so I downloaded the Spreadsheet::ParseExcel module n I'll see how that works
By 'close match" I meant, for example, if it compares Ann Palemoon and Anne Palemoon, it should return a match. I'll check the modules you mention out.
Thanks a lot, I really appreciate it.
Eyi.
I've been doing Perl for some years now and I do own a bunch of Perl books...
That one you mention there... never heard of it:-\
If I had to recommend you just one book to start with, it would definitely be, without hesitation, "Learning Perl", by Randal Schwartz [amazon.com]. [1]
Now *that* is a book.
Plus, everybody knows Randal. Those *three* authors of that book you mention? Never heard of them. I couldn't even find any of them on the CPAN or other Perl related sites, so...
Welcome, eyidearie! (Score:1)
The FAQ for this site sorta tells you that but doesn't have a link to places where you can get answers to your kind of question.
Welcome Aboard The Crazy Train (Score:1)
To give some pointers to the actual question at hand, a little more information is needed. Are you reading actual Excel files or do you have the option of reading a "save as" CSV?
If the former - consider Win32::OLE or Spreadsheet::ParseExcel
If the latter - consider Text::xSV (several more options are available, just search for CSV)
Next question - what do you mean by
Re:Welcome Aboard The Crazy Train (Score:1)
Re:Welcome Aboard The Crazy Train (Score:1)
Books (Score:1)
I've been doing Perl for some years now and I do own a bunch of Perl books...
That one you mention there... never heard of it
If I had to recommend you just one book to start with, it would definitely be, without hesitation, "Learning Perl", by Randal Schwartz [amazon.com]. [1]
Now *that* is a book.
Plus, everybody knows Randal. Those *three* authors of that book you mention? Never heard of them. I couldn't even find any of them on the CPAN or other Perl related sites, so...
But wait, there's mor
Re:Books (Score:1)
I really mean that :-) Looking forward to the results :-)
Re:Books (Score:1)