Differences from 'view' and 'export' from 'SQL Manager'

[Wartin]

I noticed that my products' description, after my test import, didn't have different lines, but just plain text all in one line.

I use the data from SQL query where I select product's description. If I press 'view' button, the description shows something like:

<div class="rte"> <p>adsf asd fasdfhal dsfash dfahsd fasjd</p> <p> </p> <p>asd</p> <p>f as</p> <p>df as</p> <p>df</p> <p>s</p> <p>long description</p> </div>

If I export the same SQL command, resulting .sql file reads:

adsf asd fasdfhal dsfash dfahsd fasjd^M
 ^M
asd^M
f as^M
df as^M
df^M
s^M
long description^M

Obviously, when I use that .CSV file in an import, the description fields get broken.

Maybe html is getting sanitized before exporting the CSV file?

Thanks!

[Wartin]

I didn't know what all these buttons in products do:

Now I know the second is an export. Very nice. The last one add that query to SQL queries.

I don't know what could be wrong, but the exported file using button number two is separated only by ;

So when I open it in for example libreoffice all the rows appear one after the other, in one line.

 

Any help will be appreciated.