Questions tagged as 'csv'

Tagged questions
2
answers

Changing the CSV Delimiter in Python

I'm having a difficulty in the cell delimiter of the CSV file, when I command the save the edited file in CSV % with% delimiter by default is escritor.writerow([linhas]) , plus I need change to , because when I open the file in Ex...
asked by 27.03.2018 / 14:35
1
answer

CSV manipulation in R

I have several files with a .csv extension, I need to read them all, however I have a problem where I have the following file range. df1 -> Cabeçalho numérico antes do cabeçalho atual 1 2 3 nome idade escolaridade joao 10 6ano B...
asked by 09.10.2018 / 20:34
1
answer

Python CSV How to rewrite only one line of the file?

I have a line that stores the following columns inside the file: ID Nome Telefone Descrição DataEntrada HoraEntrada The ID is basically the line number and it's through it that I'm going to search what line to rewrite. I know that p...
asked by 28.11.2017 / 14:45
1
answer

I need to go through the data of several txt, take specific data and generate a csv

I'm already browsing the files and accessing the data, but I need to get what's after the following line: Initial P.A.C. () P.A.C. () Match amount due 3a. part contemplation due due payment effected Balance Sopave to the top line of this d...
asked by 04.02.2018 / 00:27
1
answer

Save array to different columns with fputcsv

I'm trying to output some data from DB to csv with the following code: while($linha=$buscar->fetch(PDO::FETCH_ASSOC)){ fputcsv($out, $linha); } fclose( $out ); } which returns the entire contents of the array in a single column. Ho...
asked by 09.10.2017 / 15:39
1
answer

How to find out which line is a CSV data

Good afternoon, I have a problem that I do not know how to solve, it will probably be in PHP but I have no idea how to do this. More precisely what I need to do is: I have a website, and in it I will create a separate page, on this separate page...
asked by 12.01.2018 / 17:29
1
answer

Import decimal with comma

In SQL Server, I am trying to execute a SELECT in a * .csv file as follows: SELECT * FROM OPENROWSET(BULK 'C:\Minha_Pasta\meu_arquivo.csv', FORMATFILE = 'C:\Minha_Pasta\format.xml') AS Contents meu_arquivo.csv...
asked by 23.02.2017 / 22:26
1
answer

Read a CSV file

I was able to import csv into my cell phone, but when I try to read the file so that the application inserts the information inside the csv, an error occurs:    java.io.FileNotFoundException: table.csv:   open failed: ENOENT (No such file or...
asked by 16.06.2016 / 20:20
1
answer

CSV file saved to the bank

I have a large CVS file and need to write it to my database the first line is the fields, which I have to validate if they are right and make some changes for example first line NAME, DATANASCIMENTO, NOMEMAE second line GUILHERME FREIRE, 02/1...
asked by 14.12.2016 / 15:21
1
answer

Update .csv file when edited in Java

I have a .csv file that contains information, but when I remove information (in this case contacts) from the console output the .csv file is not being updated. How to solve? private void insertContact(String contactName) { contacts...
asked by 04.11.2015 / 18:00