Importing sequential file with double quotes in data
Posted: Mon Nov 28, 2016 8:28 am
I'm trying to import a file csv using parallel job but there is a problem with a String field. It contains "somevalue" inside, but every field is delimited with " (double) and separated with ;.
For example, if i have, as value of a String field, this value delimited:
;"abcd ""somevalue"";
This outputs a warning and the record is filtered.
Is there a solution with Parallel job without changing delimited value?
Thanks.
For example, if i have, as value of a String field, this value delimited:
;"abcd ""somevalue"";
This outputs a warning and the record is filtered.
Is there a solution with Parallel job without changing delimited value?
Thanks.