in reply to Re: difficulty reading csv file
in thread difficulty reading csv file

The original CSV looks like (it is all English): utopian yoga mat 12 58 $0.95 2/98 ads 2/98 ads 105/ +307 days 2011/07/21 08:01:00 2010/09/20 10:28:00 crescent moon yoga mat 18 58 $0.56 3/140 ads 1/140 ads + 117/247 days 2011/07/21 06:29:00 2010/11/19 12:58:00 maha yoga mat 69 91 $1.23 2/107 ads 1/107 ads 130/24 +7 days 2011/07/23 06:16:00 2010/11/19 10:33:00 silk yoga mat bag 59 91 $1.04 4/192 ads 2/192 ads 12 +0/247 days 2011/07/23 06:20:00 2010/11/19 01:12:00 unique yoga mat 170 110 $1.44 4/138 ads 2/138 ads 34 +6/708 days 2011/07/23 09:10:00 2009/08/15 10:35:00 tapas ultra yoga mat 16 110 $0.76 4/92 ads 1/92 ads +71/307 days 2011/07/23 09:46:00 2010/09/20 08:14:00 yoga mat kit 41 140 $1.06 4/197 ads 1/197 ads 115/32 +2 days 2011/07/23 10:00:00 2010/09/05 07:36:00 monster yoga mat 27 140 $0.70 1/89 ads 1/89 ads 128/ +307 days 2011/07/22 09:31:00 2010/09/20 08:03:00 organic cotton yoga mat 56 140 $1.23 8/261 ads 2/261 ad +s 130/305 days 2011/07/23 07:12:00 2010/09/22 12:16:00 designer yoga mat 67 170 $1.28 6/206 ads 2/206 ads 1 +28/247 days 2011/07/23 02:55:00 download Also, the data is obtained form a paid marketing data site so there is no direct URL provided, A window opens up with the download link (JAVASCRIPT) to download the CSV file. I am downloading manually not sure how you would use LWP::Simple to d/l that data .

Replies are listed 'Best First'.
Re^3: difficulty reading csv file
by Tux (Canon) on Aug 08, 2011 at 23:41 UTC

    Doesn't look like CSV to me at all. Maybe the download site has options to specify the format (Excel/CSV/HTML/XML/txt/...).

    And when posting data, it would be wise to use <code> tages.


    Enjoy, Have FUN! H.Merijn