Hi there I'm trying to set up a way of allowing staff at my library to manage e-resources easily.
For part of this I am using a Excel 2000 file that staff save as CSV. My biggest problem with this is that text feilds are not being saved with text qualifiers ("") so the Javascript I am running on the CSV can not read it properly.
When I've tried to physically add quotations it then saves the file with multiple quotations on either side - ""field entry"" - which is even worse.
So, does anyone know how to make Excel save to CSV with text qualifiers?
Any ideas, comments, etc. much appreciated.
Cheers
Tama
For part of this I am using a Excel 2000 file that staff save as CSV. My biggest problem with this is that text feilds are not being saved with text qualifiers ("") so the Javascript I am running on the CSV can not read it properly.
When I've tried to physically add quotations it then saves the file with multiple quotations on either side - ""field entry"" - which is even worse.
So, does anyone know how to make Excel save to CSV with text qualifiers?
Any ideas, comments, etc. much appreciated.
Cheers
Tama