Delete empty lines at the end of a CSV file with PHP

Asked

Viewed 179 times

0

Hi, I need a tip, I was making an import of a file on CSV to change a record in my database and strangely could not do it, I did an analysis in the code in PHP and it’s all right so I left for the file on CSV and found that the same after the tests I did was left blank lines at the end of it, I did a cleaning and again I remade the import process and everything worked out. Is there any possibility to delete these lines after the records at the time of import?

What I got is this:

if (!empty($_FILES)) {

        $tempFile = $_FILES['userImage']['tmp_name'];
        $Dados = file($tempFile);
        // IGNORANDO A PRIMEIRA LINHA DO CSV
        array_shift($Dados);

        foreach($Dados as $RegLinhas) {

            // RETIRA ESPAÇOS NO INÍCIO E FIM
            $Linha = trim($RegLinhas);
            // DIVIDE A STRING
            $CamposImport = explode(';', $Linha);
            // RECUPERANDO EM VARIÁVES PARA ORGANIZAR SELECT/INSERT/UPDATE
            $IdPessoa = $CamposImport[0];       
            $Nome = $CamposImport[1];
            $IdUnicoop = $CamposImport[2];
            $DataAdmissao = $CamposImport[3];
            $IdCargo = $CamposImport[4];
            $LotacaoRH = $CamposImport[5];
            $CTPS = $CamposImport[6];
            $CTPSSerie = $CamposImport[7];
            $CTPSUF = $CamposImport[8];
            $DataNascimento = $CamposImport[9];
            $CPF = $CamposImport[11];           
            // CONVERTENDO DATA PARA MYSQL
            $DataAdmissao = implode("-",array_reverse(explode("/",$DataAdmissao)));     
            $DataNascimento = implode("-",array_reverse(explode("/",$DataNascimento))); 

            // CAMPOS  FIXOS
            $TipoColaborador = "Funcionario";
            $DivulgarAniversario = 1;
            $Categoria = "F";
            $ClienteProdutor = "C";
            $Fornecedor = 0;
            $Colaborador = 1;
            $Ativo = 1;
    }
}

  • You can do an If in fields that will never appear empty. For example: If Idperson other than empty, receives other information...

  • Thanks for the tip @Brunofolle, I’ll do some tests.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.