I'm having trouble trying to export a csv file from a Joomla database which contains some HTML. I can see the data laid out perfectly in PHPMyAdmin when I carry out an SQL command like this:
However, when I try to export the data as a csv file, everything goes a bit awry (I'm assuming it's because there's a delimiter in the introtext or fulltext HTML). When I try to open the file in Numbers (Mac equivalent of Excel), there are multiple rows i.e. it's not in the same tabble format as in PHPMyAdmin.
SELECT `id` , `title` , `alias` , `introtext` , `fulltext`
The settings I'm using in PHPMyAdmin to export the data are:
Does anyone know what I can try as I'm new to this?
Export : CSV
Fields terminated by : ,
Fields enclosed by : "
Fields escaped by : \
Lines terminated by : AUTO
Replace NULL by : NULL