Has anyone encountered a situation where they had to parse a CSV file that contained JSON strings in one of the "fields"?
I am using Scott Klement's CSVR4 service program to parse a CSV file and I'm wondering if it is possible to ensure the JSON strings that are in the file retain double quotes.
Here's a sample row of the CSV I am dealing with.
After opening and loading the CSV file, the results are as follows (I will list each field on its own row for read-ability:
123 Mockingbird Lane
I am omitting string and field delimiters when calling CSV_open, so doubles are used for field delimiters and a comma is used for the field delimiter.
The problem is that I cannot successfully parse the JSON because the double quotes are missing.
My 2 cent are I don't know why anyone would imbed JSON strings in a comma separated file, but that is out of my control in this situation.
Any ideas would be greatly appreciated.
This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact