Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • 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)

    Next question - what do you mean by near match? It is likely that you can get by with String::Approx or Text::Levenshtein but more information is needed to know for sure.

    Cheers,
    L~R