You're very close there. See where it says "other" for the delimiter? You have it set as a comma. Change that to a double quote by checking the "other" Boolean and setting the delimiter to double quote. The text double quote is used to identify text columns so it doesn't get confused with what is inside the double quotes.
Can you check your descriptions and see if any of them have a double quote? Wondering if that might be the issue. I don't see anything wrong with the file that you shared but I can't see the whole description.
Please see the data from my file below. The third column ' Description' has double quotes in it, but to distinguish them we add \ before the double quote. If that will not solve the issue, then any suggestion on how to workaround this?
@praba71 The error is coming from the description field: The Description contains double quotes characters... If you used the "Text Delimeter" property as double quotes character, then in the file you need to have 2 double quotes... and you have the \" instead: ("WD 600GB SAS, 10K, 2.5\" (WD6002BKTG)"
The only way to solve this is to replace \" with "" in your file.
"WD 600GB SAS, 10K, 2.5\" (WD6002BKTG)" needs to be replaced with "WD 600GB SAS, 10K, 2.5"" (WD6002BKTG)"
Anaplan does not recognize as escape character the backslash (\) but...instead.. the double quotes character needs to be doubled in the file ("")