I am trying to import data from a CSV file separated by &#39;;&#39; and with string values surrounded by double quotes: &quot;<div><br></div><div>but I keep getting the following error messages:</div><div><br></div><div><div>

missing separator &#39;;&#39; line 225387 expecting 8 got 7  fields</div><div>missing separator &#39;;&#39; line 75129 expecting 8 got 7  fields</div><div>missing separator &#39;;&#39; line 0 expecting 8 got 7  fields</div>

<div>missing separator &#39;;&#39; line 450774 expecting 8 got 7  fields</div><div>missing separator &#39;;&#39; line 300516 expecting 8 got 7  fields</div><div>missing separator &#39;;&#39; line 150258 expecting 8 got 7  fields</div>

<div>missing separator &#39;;&#39; line 525903 expecting 8 got 7  fields</div><div>missing separator &#39;;&#39; line 375645 expecting 8 got 7  fields</div><div>failed to import table</div><div><br></div><div><br></div><div>

I am using the following command:</div><div><br></div><div>copy 300000000 offset 2 records into mobilidade.ligacoes from &#39;/Users/fccoelho/Documents/dados_mobilidade/bilhetagem.txt&#39; using delimiters &#39;;&#39;,&#39;\n&#39;,&#39;&quot;&#39; ;</div>

<div><br></div><div>after creating the table like this:</div><div>sql dump of my table:</div><div><br></div><div><div>CREATE TABLE &quot;mobilidade&quot;.&quot;ligacoes&quot; (</div><div>&quot;id&quot;                        INTEGER       NOT NULL       DEFAULT next value for &quot;mobilidade&quot;.&quot;seq_5840&quot;,</div>

<div>&quot;DT_INI_ATIVIDADE_REDE&quot;     VARCHAR(10),</div><div>&quot;HR_INI_ATIVIDADE_REDE&quot;     VARCHAR(7),</div><div>&quot;NU_SETOR_CELULA_ORIG&quot;      INTEGER,</div><div>&quot;NU_AREA_CELULA_ORIG&quot;       INTEGER,</div>

<div>&quot;NU_DDD_ORIG&quot;               INTEGER,</div><div>&quot;NU_DDD_DESTINO&quot;            INTEGER,</div><div>&quot;CD_TELEFONE_ORIG_ALTER&quot;    INTEGER       DEFAULT NULL,</div><div>&quot;CD_TELEFONE_DESTINO_ALTER&quot; VARCHAR(16)   DEFAULT NULL,</div>

<div>CONSTRAINT &quot;ligacoes_id_pkey&quot; PRIMARY KEY (&quot;id&quot;)</div><div>);</div></div><div><br></div><div>Naturally, I checked line 0 and it does have 8 fields.</div><div><br></div><div>What am I doing wrong?</div>

<div><br></div>-- <br>Flávio Codeço Coelho<br><br>
</div>