NIFI- CSV and Put Database Record - Invalid character between encapsulated token and delimiter

[#1]

Hi,

I was able to load most of the data with putdatabase record. But few of the files fail with data exception as invalid character between the quote and delimiter.

|"COMPANION\SMALL ANIMAL RESIDEN"|"COMPANION\"

My assumption is \ is causing error. Is there any easy way to handle that in CSVReader inside PutDatabase processor? or do I need to do something else.

My quote character is " in csv reade r

My escape character is \

My assumption is since escape character is same as value present inside the column value, error is thrown. May I know how to resolve this?

Thanks,

Khaja

[#2]

Hi,

I am also facing the same issue. If you found the solution could you please share ?

Thanks!