Invalid number of fields in CSV at line 1

Solved
bretonm2004 Posted messages 320 Registration date   Status Member Last intervention   -  
pitxu Posted messages 708 Status Member -
Hello,

I have a small problem. I created a CSV file and when I import it I get this error

Invalid number of fields in CSV data at line 1

My table includes id, ranking, and city

Here is an excerpt of my file

id;ranking;cities;
1;1;;
2;1;Acme;
3;1;Airdrie;
4;1;Alberta Beach;
5;1;Alder Flats;
6;1;Alix;
7;1;Alliance;
8;1;Altario;
9;1;Andrew;
10;1;Anzac;
11;1;Ardrossan;
12;1;Arrowwood;

Thank you

Configuration: Windows 7 / Internet Explorer 8.0

3 answers

  1. pitxu Posted messages 708 Status Member 95
     
    Hello, the double ; on the first line maybe ...
    0