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!