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!