I have a CSV with the following data
19,john doe,blue car,NAY,NA,YAY,,NIL,,,,NA,,
There are 14 fields in the above line, but when I try the automatic field extractor via "Extract more fields", It only recognizes 13 fields.
Why is the field extractor dropping the last field ?