[HS] Re: Version question
"g_blunier" <[email protected]> Sun, 26 Aug 2012 18:58:07 -0000
| Newsgroups | gmane.comp.handhelds.palm.handyshopper |
|---|---|
| Message-ID | <[email protected]> |
I recall having this same problem and using a text editor to eliminate the quotes in just the first line to get HS3convert to work on the output from OpenOffice. Greg B. --- In [email protected], "holsteinfrisiane" <e-post2011@...> wrote: > > Okay, I figured out part of the problem. OpenOfficeCalc changes the notation of the CSV when saving, surrounding every value with quotes (the CSV file out of HS3convert does not have quotes). This makes HS3convert choke on the file on re-import. > > I haven't been able to "repair" the problem by simply finding and deleting the quotes. Additionally, due to the missing quotes commas in values (e.g. "T-Shirt, blue") are interpreted as value separators when importing the CSV to OpenOffice, and I get additional columns/fields per entry, breaking the data set.