Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery

Re: Joininig excel columns from many files

by Not_a_Number (Prior)
on Jul 27, 2011 at 19:28 UTC ( #917112=note: print w/replies, xml ) Need Help??

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

  • Comment on Re: Joininig excel columns from many files

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.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://917112]
[holli]: :) No. I might be small, but you don't want to be around me when I flip.
[LanX]: I can imagine ...
LanX hurts to be bitten between the legs ;-)
[holli]: You see, I have a friend whose daughter has been damaged seriously because she wasn't vaccinated against measles. (Her mother being anti-vaxx).
[LanX]: Contrary to Olivia newton John I don't like physical confrontations ...
[LanX]: Oh, you spread measles in your saliva?
[LanX]: ... and why did you bite hos daughter?
[LanX]: *his
[holli]: And this guy was also Anti-Vaxx and I just snapped. I shoed him all over the yard
[james28909]: biting between the legs? now thats my kind of religion.

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (12)
As of 2017-12-13 18:04 GMT
Find Nodes?
    Voting Booth?
    What programming language do you hate the most?

    Results (373 votes). Check out past polls.