I am exporting all of my posts from phpMyAdmin as a CSV file using , as the column seperator and "" as the text delimeter.
The export works fine but when I open it up in something like OpenOffice, the columns are still broken up where it finds a , in the sentence of either the post or title.
I have been at this for a while now and in the past, and I would like to know if there is a better way to go about this?
At the end of the day, I need to be able to open this CSV file so that I can delete some columns which will not be used and re-imported as products for WP eCommerce. I have another post similar to this, but that did not get me what I want either.