mamica 10 Posted October 30, 2014 Report Share Posted October 30, 2014 I scrape data from wbesites in a rows. I use title, description and tags. And i use delimiter. but every time i check my csv file it is a mess. Whatever delimiter i use it is always a mess. i dont know why it sees new row in description as new row in openoffice. I even try to use table, i place evrything really nice in table inside ubot, and everything looks nice, everything is in right column but when i open with openoffice it is a mess again. Anyone can help me out here? Quote Link to post Share on other sites
LoWrIdErTJ - BotGuru 904 Posted October 30, 2014 Report Share Posted October 30, 2014 remove the commas from the content your scraping.before setting it to a cell. as when you open it its thinking that is new columns where the commas are located. Quote Link to post Share on other sites
mamica 10 Posted October 30, 2014 Author Report Share Posted October 30, 2014 But then my dewscriptions will be mess. I used special delimiter for saving csv, |But i think if descriptions is writen in each row like this: One line f some text.Second line of new textthird lines of new text. It makes 3 rows and it is all just 1 description which should be in 1 cell. How do u work this out? Quote Link to post Share on other sites
LoWrIdErTJ - BotGuru 904 Posted October 30, 2014 Report Share Posted October 30, 2014 then at the top of your software click on options, bot propertiesand change delimiter that your csv has. to something like | or anything other than commas. and have yoru csv reader use the same delimiter. Quote Link to post Share on other sites
UBotDev 276 Posted October 31, 2014 Report Share Posted October 31, 2014 Maybe try to use semicolon instead ";", my Excel uses it for csv delimiter. Btw, you also don't need to remove delimiter character from the cell...if cell contains it, or contains a new line character, that cell value should be surrounded with double quotes, and it should still show in one cell once you open it in Excel or similar. 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.