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 best solutions below