Jump to content
UBot Underground

Exporting results as CSV file - problem


Recommended Posts

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?

Link to post
Share on other sites

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 text

third 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?

Link to post
Share on other sites

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.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...