MobileRead Forums - View Single Post

MontyJ · 12-08-2012, 02:27 PM

Kiwidude,

Just for a lark, I took the first 23 records from this file and made another .csv file with only those records; I am able to get to Step 2 using those 23 records!

So, it appears as tho there is a bad character/symbol somewhere in this file. I will look at my export settings from OOO Calc and see if I use quotes or some other setting if I can negate the error.

MJ

[Edit] I did an export from my ODS spreadsheet file with quotes (" ") surrounding all text in the two fields, and using a TAB as delimiter. I do have commas n the title fields, so I thought that may have been causing the hiccup somewhere further down in the .csv file. But even with the fields quoted and using a TAB as delimiter, it still hangs...

[Edit] I split the .csv file roughly in two; authors A-J, and then the second half K-Z. The first half works ok and lets me go on to Step 2, but the second half still will not. So if it is not something to do with the number of records, then it must be a bogus character in the K-Z file.

12-08-2012, 02:27 PM	#14
MontyJ Addict Posts: 224 Karma: 10 Join Date: Jul 2012 Device: Kindle	Kiwidude, Just for a lark, I took the first 23 records from this file and made another .csv file with only those records; I am able to get to Step 2 using those 23 records! So, it appears as tho there is a bad character/symbol somewhere in this file. I will look at my export settings from OOO Calc and see if I use quotes or some other setting if I can negate the error. MJ [Edit] I did an export from my ODS spreadsheet file with quotes (" ") surrounding all text in the two fields, and using a TAB as delimiter. I do have commas n the title fields, so I thought that may have been causing the hiccup somewhere further down in the .csv file. But even with the fields quoted and using a TAB as delimiter, it still hangs... [Edit] I split the .csv file roughly in two; authors A-J, and then the second half K-Z. The first half works ok and lets me go on to Step 2, but the second half still will not. So if it is not something to do with the number of records, then it must be a bogus character in the K-Z file. Last edited by MontyJ; 12-08-2012 at 03:03 PM.