0

I am having trouble importing rows from a tab-delimited CSV file into a fusion table database when the file contains fields with quotation marks. I still can't do it even if I change " to \"

The error message I see in the Google Drive interface is "Incomplete import at "Adding rows from file." Unable to parse your file: Quotation mark found in unquoted value at line 1, column 82".

What is the trick to solving this problem? As mentioned, \" doesn't work and neither does "" (doubling).

user1469420
  • 121
  • 1
  • 1
  • Try deleting the double quotes, `tr -d '"' < input.csv > output.csv` – Mark Setchell Mar 21 '15 at 22:55
  • Doubling the double quotes should work. Is the value with the double quotes itself enclosed in quotes? The message indicates not; that is, foosome "thing" here would not work, but foo"some ""thing"" here" should. – Rod McChesney Mar 22 '15 at 05:48
  • No, the value with the double quotes is NOT itself quoted. My workaround is to convert all double quotes to single quotes but I really want those double quotes. – user1469420 Mar 30 '15 at 05:40

0 Answers0