Search found 5 matches
- Thu Oct 16, 2008 3:46 am
- Forum: Support
- Topic: Export to CSV
- Replies: 7
- Views: 7387
Re: Export to CSV
Excel, much like Word, "rarely misses an opportunity to perplex" (Bob Buckland, as quoted at http://word.mvps.org/ ). :D I've sent you a zipped file with the .bcard file for the book entry that's causing the funky character, plus an old .txt export and the corresponding .xls file which bot...
- Tue Oct 14, 2008 11:00 pm
- Forum: Support
- Topic: Export to CSV
- Replies: 7
- Views: 7387
Re: Export to CSV
Downloaded the beta and tried the export again, both as CSV and tab-delimited. Yup, the CSV export is still messing up those quotation marks in Excel. Just like you, I see them escaped in the text file -- hadn't looked at those earlier because they make me go cross-eyed, :lol:. One thing I still not...
- Tue Oct 14, 2008 9:50 am
- Forum: Support
- Topic: Export to CSV
- Replies: 7
- Views: 7387
Re: Export to CSV
I saw where it tried to do that: \Teach Yourself in 24 Hours\" (that's a little empty rectangular box as the first character; at least, that's what I see...) As you can see, the escape code is there for the first quote, but the quote isn't. Any commas after that in the text get interpreted as ...
- Tue Oct 14, 2008 9:25 am
- Forum: Support
- Topic: Export to CSV
- Replies: 7
- Views: 7387
Re: Export to CSV
1. The quotes in summary should be escaped, they should be turned into \" and Excel should have no issue ignoring them. If the quotes in the summary are not getting escaped for you do let us know, so that we can dig deeper. (It might be the subjects field causing the new entries.) I saw where ...
- Mon Oct 13, 2008 11:46 am
- Forum: Support
- Topic: Export to CSV
- Replies: 7
- Views: 7387
Export to CSV
First of all, Bookpedia looks like a great program! :) However, I'm having problems exporting to CSV. Or, rather, importing that export into MS Excel... There are several flies in the ointment: 1 - If something in the "Summary" has quotes around it, it throws the whole thing off and from t...