Questions tagged as 'csv'

2
answers

Export mysql table in CSV

I am trying to export a table from mysql to csv. This I have already achieved but in the csv file the fields of the exported columns do not appear. The code I have used is the following: select Nombre,Direccion INTO OUTFILE 'prueba.csv'...
asked by 08.06.2016 / 22:47
1
answer

How to convert the delimiter of a csv file

I have a .csv file which each column and its contents is separated by commas. What I'm looking for is to be able to change each comma separator with a Pipping (|) and do this in C #. I've searched on Google but I can not find anything conc...
asked by 23.01.2018 / 19:59
2
answers

Read all the txt files in a folder and then work with them

What I'm working on now is a thread that has to constantly look into a "My Documents" folder and see if it finds files .txt . If you find them, read them, validate the data and send them to the database. The issue is that I had alread...
asked by 14.12.2018 / 07:03
1
answer

How to convert a csv (unicode) file to csv (utf-8) in python 3.6.5?

I download a CSV (unicode) file from a website, the fields are separated by tabulation and in double quotation marks and the line break does not do it at the end of each row of how it looks in the CSV, example of how it is see the CSV informatio...
asked by 11.09.2018 / 08:04
1
answer

Migrate CSV file to HBASE

I am learning how to use hadoop and hbase and I am presented with this problem that has something tangled in all these technologies. I have about 24 hadoop fedora and it was working. and I have some databases in CSV file. I want to upload the...
asked by 19.08.2016 / 11:11
4
answers

Illegal character in output

I have an application that exports the result to me in a .csv file. The export makes several project names, one of those projects has the tag name in HTML <b> . When trying to create this file, I get an illegal character in pat...
asked by 17.10.2016 / 17:00
2
answers

Comparison List of lists and list python

I am looking to make a comparison of a list with a list of lists. With this code I can do it between 2 lists but the problem happens when it is a list with a list of lists. I am looking to edit my code to be corrected. lista1=["paco","pepe"...
asked by 11.12.2017 / 21:29
1
answer

Obtain the ID of an Order, at the moment of sending it by PHP to BBDD (For a CSV)

I try to do the following: When you send a FORM , you generate an order, which, through Ajax, you send to the database. Next, I have another Ajax, (both in jQuery when submitting) that pulls out a csv file from the order: <?php $c...
asked by 30.08.2018 / 16:01
2
answers

Filters Data URL CSV Python

I'm working with a report I get from a URL. I'm looking to make filters which return only the data from the Fillrate column less than 0.05 along with the name, request, impressions data and once obtained only those values saved in a CSV. I do no...
asked by 02.10.2017 / 20:51
1
answer

Print a column of a csv

I have a csv file several columns. I simplify it in the following case with two. ID texto 1 Los niños comen sardinas 2 Los pájaros vuelan alto porque tienen alas 3 Érase una vez la vida 4 Un 67% de los adultos vive en l...
asked by 03.11.2017 / 17:53