qlik script

[saikripa]

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

[anat]

can u share some sample data ,so that it is easy to address the problem.

[saikripa]

 the csv looks like this. the third field in line number 4 has special characters

[anat]

can u try using keepchar like..

keepchar(sc,'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ') as sc

[saikripa]

getting this error

Connector reply error: Unknown substring, string, or value at (17,34): ''abcdefghijklmnopqrstuvwxyzABCDEFGH'