Search found 5 matches

by TexasT
Thu Oct 16, 2008 3:46 am
Forum: Support
Topic: Export to CSV
Replies: 7
Views: 7520

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...
by TexasT
Tue Oct 14, 2008 11:00 pm
Forum: Support
Topic: Export to CSV
Replies: 7
Views: 7520

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...
by TexasT
Tue Oct 14, 2008 9:50 am
Forum: Support
Topic: Export to CSV
Replies: 7
Views: 7520

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 ...
by TexasT
Tue Oct 14, 2008 9:25 am
Forum: Support
Topic: Export to CSV
Replies: 7
Views: 7520

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 ...
by TexasT
Mon Oct 13, 2008 11:46 am
Forum: Support
Topic: Export to CSV
Replies: 7
Views: 7520

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...