http://www.perlmonks.org?node_id=917112


in reply to Joininig excel columns from many files

Hi, dtm81, and welcome to the Monastery.

First of all, I'd like to point out that when you post a question here, and one of the earliest replies requests further elucidation, it is considered bad form not to respond. In your case, dcmertens asked you:

What do you mean you need to store the data 'somewhere until all the files are parsed'? Does the amount of data exceed a RAM limitation or are you just inquiring how you would build the nested data structure?

More than four hours later, you still haven't replied.

Of course, you might have been unavoidably detained elsewhere, eg by having your house burned down. In which case, no apologies are necessary. Otherwise, if you return to this thread, please do dcmertens the decency to reply to his post.

Thank you

Replies are listed 'Best First'.
Re^2: Joininig excel columns from many files
by dtm81 (Initiate) on Jul 28, 2011 at 11:39 UTC
    Fortunatelly i am currently working as well, so maybe you should think that i am busy working to something else... And i am very greatfull that peoples are trying to help here, thank you all for the quick solutions that you bother gave me :) To respond to our colegue's question, i usually write a script that will be OK for 20 lines as well as for 2 billions of lines, so i was thinking i will use threads to split the file in. As a quick solution, indeed i will export the file into a csv format and just the task to be done quick, but i ll want to "beatify" the script as i mentioned earlier. I think the solutions are more than enough, so i ll stop here... Cheers, to all!
      Had time this weekend, to "meditate" on it... The implementation was without external module, but with a "big" - hash of arrays, that i parsed it later on... It was in a way funny in the end, because i forgot to set the IFS to \r\n, reading from win files :) but finally thought of it... Any way i found a nice module: Spreadsheet::ExcelHashTable that is parsing the excel files straight into the hash... Thanks to all! Proud to be a part of this community.