Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re^8: Parse .csv file from FTP using Perl

by Sherlock Perl (Novice)
on Jun 21, 2012 at 01:58 UTC ( #977533=note: print w/ replies, xml ) Need Help??


in reply to Re^7: Parse .csv file from FTP using Perl
in thread Parse .csv file from FTP using Perl

Thank you so much. I will try both of the methods and choose whichever I find easier to understand. Do you think it would be easy to alter the code if for example the two rows with values start not from the beginning but from some other cell. For example they are in the range "d4:n5" or any other similar range? If you are in nyc your beer or whatever you drink is on me :)


Comment on Re^8: Parse .csv file from FTP using Perl
Re^9: Parse .csv file from FTP using Perl
by muba (Priest) on Jun 21, 2012 at 02:03 UTC

    Oh yeah, it's definitely possible. Especially the second approach, because the ->getline_hr_all method allows you pretty much to limit the rows Text::CSV should look into. As for limitting things horizontally, that will prove to be a little more tricky, but it isn't impossible at all. I'll leave that up to you, though. You'll eventually end up with something that's a mix of both of my approaches, I think.

    Just read the documentation for Text::CSV - it's pretty elaborate but written in a clear and understandable manner. FYI: I never used that module until just now, so working with Text::CSV was new to me, and I figured it out just by following the documentation.

      Thank you again, I am sure I will figure it out. I will make sure to post the final version so people with similar questions can benefit :)
      Hi I tried the code and the 2nd one is really preferable (I even understand it better than the first option). However, I have been trying to change so that for example I give the code the reference "Cat" and it returns me "Dog". What I mean is that it searches the 2nd row for the position not the first one and I cannot do it yet. I have been reading the Text::CSV_XS file but I find it a bit hard to grasp (I guess beucase I am still a little confused with the Perl way of working/thinking). I understand that I need to make the change in either getline() OR getline_hr_all but not sure where and what. I think all I have to do is make getline read from the 2nd line for example but I don't know how to do it. Any suggestions? Thanks in advance!

      EDIT: I figured it out. What i did was instead of using getline() I used getline_all and then all I have to is offset as much as I want. Thank you all, if I have more questions I will feel free to ask :)

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://977533]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (9)
As of 2014-12-29 09:55 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (185 votes), past polls