Hi George!
I guess the settings you've set wouldn't work.
Is far as I understand, "enclosureSign" parameter determines the boundaries within which the content should stay untouched. For example, in case of row contents like:
"field1","field2","fi,eld3"
your settings would work as expected.
In other cases this option is useless, I guess. Just ask yourself: how should FCC distinguish comma acting like a separator from the same comma, which is the part of field content.
So I think the decision might be to use fixed field lengths for source file or to use some "enclosure sign" for field content, for example ~field~ or "field".
Regards, Evgeniy.
Add comment