Hello All,
I am storing my data from csv to qlik QVD in data load editor. My csv contains special characters in one field and is causing the error : "Error: Unexpected symbol '\'(#92) at (line 1009132, col 76). Delimiter ',' or EOL is expectd."
this is the value in the csv for column names col_sc , "ee\"\"". it should have been only ee. I cannot manually edit the csv.
I tried the following :
SOURCE_CSV:
SQL SELECT
"a",
"b",
replace("col_sc", Chr(92), ' ') as "col_sc",
"d",
"e"
FROM CSV (header on, delimiter ",", quote """") "SOURCE_CSV" QDL WITH CONNECTION(URL "$(URL)");
but getting the error: Connector reply error: Unknown substring
