I'm getting an export file of VSAM data from a vendor in what is supposed to be comma-separate format with quoted strings. But the data contains a text field that itself contains quotes, single quotes, commas, carriage returns, etc.
So of course it is not parsing correctly.
Does anyone know of a document online that has accepted standards for forming quoted strings? I would like to be able to point the vendor towards it, so they can generate something I can use.
If it's not practically useful, then it's practically useless.
Generally, fields containing commas, newlines, or double quotes must be enclosed in double quotes, otherwise they're optional. Double quotes are themselves escaped with another set of double-quotes. However, there really isn't a formal specification, so the exact format may differ, though certainly it should be consistent within a document.