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?