Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

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

New Contributor

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