We are getting new line character in one the column of a CSV file. The data for the column is coming in consecutive rows. Eg:
ID,CODE,MESSAGE,DATE,TYPE,OPER,CO_ID
12202,INT_SYS_OCS_EX_INT-0000,"""OCSSystemException: HTTP transport error: java.net.ConnectException: Tried all: '1' addresses, but could not connect over HTTP to server: '10.244.166.9', port: '8080'
failed reasons:
[0] address:'/10.244.166.9',port:'8080' : java.net.ConctException: Connection refused
""",06-09-2021 05:52:32,error,BillCycle,6eb8642aa4b
20840,,,06-09-2021 16:17:18,response,changeLimit,1010f9ea05ff
The issue is for column Message
and id 12202
, in which data is coming in triple quotes and in consecutive rows.
My requirement is that for the column Message
, the data should come in a single row rather than multiple rows, because my etl loader fails to import an embedded newline.