We have configured the string delimiter as double quote in the Data loading activity.
However, we found that the content of a column contains the double quote which crashes the data import and that row till be skipped.
How should we handle this case so that the row of data can still be imported?
@WastonAdobe- this is a common problem, but doesn't have any really nice fixes if you are using the built-in functionality to import the incoming files.
Most of the fixes would require upstream fixes: e.g.
The best method is usually 1 and/or 2 as whoever/whatever is creating the data file should have the responsibility to provide you with correctly formed data.