in reply to Re^5: parsing CSV
in thread parsing CSV

This is still not working. I'm not sure what the problem is. Essentially Each webpage shows me a page of data represented in csv format. Just a single blank white page with data. Currently in our office we we run a curl command on each webpage to send that data in an email. One webpage has customer id and storage size the other webpage has those same customer id but with the customer names associated with the customer id.
What I'm trying to do is take both of those web pages data and match their the customer id and storage size to the corresponding customer id and client name on the other put that into a new csv format and email that information to whoever needs it in the body of the email.
In short. I need to take two web pages, match and concatenate the data and email it.

Replies are listed 'Best First'.
Re^7: parsing CSV
by marto (Cardinal) on Oct 08, 2016 at 17:57 UTC

    Can you post an example of each of these pages (with fake customer data, obviously) and what the output you require is? With access to the right data and an example of what you want the output to be it'll be easier for people to help.

[reply]
      webpage 1 is a blank page with two columns: 
      storage, cid
546  ,   c100
6234 ,   c200
3265 ,   c300
etc  ,   etc

      [download]
      web page 2 is also a blank page with data but no columns just data: 
      c100, jo shmo c200, jack black c300, patrick stewart
c400, may shoe c500, dick tracy c600, morgan freeman
c700, michael jordan c800, vladimir putin c900,
corey feldman etc, etc etc, etc

      [download]
      I have to take the cid and name on page 2 and match it to cid and storage on page 1. Some magic happens and it concatenates into a csv or $output variable or anything really that can get put onto the body of an email that displays: 
      CID, Name, storage size
c100, jo shmo, 546
c200, jack black, 6234 
etc, etc, etc

      [download]
      I have to somehow take those urls and download the info concatenate and match the data together and send said data in body of email
[reply]
[d/l]
[select]
        Any thoughts, Monks of Wisdom?
[reply]

In Section Seekers of Perl Wisdom