Re: Parse a CSV format record with embedded double quote

On Wed, Aug 30, 2017 at 11:31 AM, Alan Shore <ashore@xxxxxxxx> wrote:

The assumption here is that a field will contain 2 contiguous double quotes
What happens if the field contains one - or even worse - a number of
non-contiguous double quotes

I hate using comma, single quote or double quote as a delimiter - much
rather use tab - but even THAT is not guaranteed to be with no problems

Exactly. I've even seen that "logical negation symbol" (ASCII 170), and I
can't remember the last time I've seen that on a keyboard. Our app
converts native DB2 data to .csv files we send to our Oracle group, and we
have no control over what is in the original data, which comes to us from
our clients. In particular, we get a "notes" field that CSRs can enter in
anything from the keyboard. I'm not sure why a CSR would ever type three
consecutive double quotes in a note, but I'm in no position to ask, and
CPYTOIMPF resolves the issue so that I don't need to care. CPYTOIMPF
handles this just fine.

- Dan