0

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!

Sandra Rossi
  • 11,934
  • 5
  • 22
  • 48
Anuj
  • 1
  • 1
  • Does this answer your question? [Import flat file containing commas/quotes into SAP BODS](https://stackoverflow.com/questions/24677937/import-flat-file-containing-commas-quotes-into-sap-bods) – Suncatcher Jul 23 '20 at 11:43
  • Hi @Suncatcher. Unfortunately it doesn't. The data in my case is sent by the client so we can't make changes to it. – Anuj Jul 23 '20 at 18:30
  • don't duplicate the same questions https://stackoverflow.com/questions/61456032/reading-csv-file-with-double-quote-delimiter-in-sap-bods, make research before posting – Suncatcher Jul 24 '20 at 09:49

0 Answers0