Well a. i'm a new employee and the file we get are text qualified with "" and comma delimited. so a row looks like this
"some text","some text2","some name "BookTitle" to buy ", "end"
when the package sees a " it thinks that its the end of the field, and complains that it can't find the , after the "
I talked my supervisor about saying it isn't text qualified, but that would mean the "" would show up in our rows.
I guess based on all the responses we can ask for a different delimiter or for them not to include the "" in the title names, but i need some solution to load these things because a change is probably not going to happen super fast.
Right now all i can do is open the file and manually remove the lines or fix them.