sarge 0 Posted April 9, 2018 Report Share Posted April 9, 2018 I haven't used Ubot for ages, so I'm a bit rusty, but this problem seems odd to me.I've scraped data from multiple pages, adding to two lists. One is a product title, the other a description, an example page is here: http://cateringequipment-uk.co.uk/proddetail.asp?prod=Lincat-OG7502-Atmospheric-Steamer&cat=242 I then add lists as a column to a table, column one and two. The debugger looks fine: So then I save to file: save to file("C:\\data\\customersData\\catering equipment\\prods\\table.csv",&allscraped) And all I get is this: Only the first line of the description is being saved in the cell. Am I doing something silly here? Quote Link to post Share on other sites
bestmacros 60 Posted April 9, 2018 Report Share Posted April 9, 2018 check for commas - CSV is the Comma separated value file - it can split content if you try to save the text with commas Quote Link to post Share on other sites
Code Docta (Nick C.) 638 Posted April 10, 2018 Report Share Posted April 10, 2018 What happens when you click on a cell? Do you see the rest in the editing bar above? You may have to wrap your text(description) in "Quotes" to make it one string. Or it may be your delimiter. In the menu at the top of UBot there is a "Bot" button, you can change it there. Regards,CD Quote Link to post Share on other sites
sarge 0 Posted April 10, 2018 Author Report Share Posted April 10, 2018 Hi guys, Checked again, set the delimiter to ';' and that appears to have worked. Thanks! Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.