Reading CSV file in SAP Data Services using double quotes as text delimiter - but only single double quotes in column value

1.6k views Asked by At

I am reading a CSV file in SAP Data Services Designer and using " as text delimiter. The client sometimes sends data that only has one double quote in a column, without a closing " which would mark the end of string.

Because of this, it ends up reading next many rows as one single column, until it encounters the next ".

I need to retain the " as text delimiter as that is also required.

Is there a way to avoid the anomaly where the software only sees one "?

Thanks!

0

There are 0 answers