Scraped document not displaying well
I tried scraping a site that has a link whose file i want to download. it's a .txt file, but by the time i wrote it into my .csv file, it had lost its formatting. i mean it does not display well when opened with excel spreadsheet. I don't know what I am doing wrong or what i should be doing... Any ideas please?
Sample of my problem
Below is the link that holds the file I want to retrieve and I want it to retain its format when opened with excel spreadsheet. But when I worked on it, it lost its formatting such that all the data was showing in one line and a single column.
Download to CSV
'Dapo Lawore
That link isn't working.
That link isn't working.
Examples, please
dapor,
Could you please post a few example lines of the original and a few lines of the scraped txt/csv file? Be sure to surround your examples with <code></code> tags to ensure the formatting is retained. Feel free to change the content if you need to for privacy reasons.
Also, it would be helpful to know what screen-scraper method you're using to download the file.
-Scott