Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

Many thanks!

share|improve this question

migrated from wordpress.stackexchange.com Oct 9 '12 at 12:51

This question came from our site for WordPress developers and administrators.

    
This really doesn't have much to do with WordPress. Would probably be better migrated to SO, or perhaps DBA –  anu Oct 9 '12 at 8:56
    
No, it's very much got to do with WordPress because I need to be able to import the content back into WP eCommerce. Thanks –  SixfootJames Oct 9 '12 at 10:10
1  
Sure. I understand the source and eventual destination is WP, but it just feels like the actual issue is how to export CSV and then delete columns. Have you tried exporting to tab separated values (TSV) instead - that might solve the issue of commas being recognised as delimiters? I'm pretty sure there's a TSV export plugin –  anu Oct 9 '12 at 10:13
    
Thanks Anu. I am going to try pfefferle's idea first and then yours if I don't come right. –  SixfootJames Oct 9 '12 at 11:39
add comment

1 Answer 1

up vote 0 down vote accepted

have you tried to use a less used character as delimeter for example the "~"? And be sure to add only this character on the import!

share|improve this answer
    
Thanks pfefferle, let me try that. –  SixfootJames Oct 9 '12 at 11:39
    
Worked a charm! Thanks Pfefferle –  SixfootJames Oct 10 '12 at 18:40
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.