• natarshia.peck (3/9/2011)


    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.

    Your idea about importing as not text qualified has some merit. You could bring the data in 'as is' and then run some UPDATE commands afterwards that would tidy most of it up (by removing the first and last character of the offending fields, where field length > 2, perhaps).

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.