72 Solved Topics
Remove Filter | |
Hi All, i would need some advice from you guys from this forum to solve the reading of the CSV file that i had. for example, i have a file which consist of about 2000 records (below are the example of the records) 10/10/2013 10:25:09 AM,5.89,45,264.83,PTTTT 10/10/2013 10:25:13 AM,5.89,2000,11780.00, Some … | |
Hi i am having 3rd party csv file. i am having php uploading script to upload the datas into my table. while uploading datas into my mysql Table mean while it has to remove duplicate entries rows from CSV file. Please help me | |
| Hi all, I'm trying to replace text in a CSV. The CSV line looks something like this: "Field One","Field Two","Field Three","Field Four" So I tried something like: (Get-Content $csvfile) -replace "Field`n", "Field" | Set-Content $csvfile |
I am at my wits end. I have written this query which is aimed at importing my csv data uinto mysql table 'refs' load data local infile '/home/amaina/Documents/march2016.csv' into table refs fields terminated by ',' enclosed by '"' escaped by '' lines terminated by '\n' ignore 1 rows; My pain … | |
hi! i want to place the contents of a dictionary into a csv file. Can someone help me with this? i already have the code in reading the csv file [CODE] import csv reader = csv.reader(open("c:\sample.dat")) for row in reader: print row [/CODE] i want the first element of the … | |
I am currently troubleshooting a utility that I have been working on. The main file of the utility is below. Please not that `flatten_dict` and `makerows` are seperate files and functions, respectively. My objectives are to: * Recursively traverse a directory - done * Find XML and text files only … | |
I am currently attempting to work on converting a fairly sizeable JSON object and convert it into a CSV format. However, when I attempt to do so, using a conventional approach (that seems to work with other files). I am presented with a "ValueError: too many values to unpack" I … | |
Here's dish. When I submit a form, it straight up crashes my site on my network. Here are the details. 1. The form submits to itself. The form is on site.php (fictional name for reference on this post) and the action= "site.php". 2. When it crashes, it crashes for every … | |
I need to process a CSV file and create a new CSV file. In order to get a proof of concept, I placed the CSV on the server and was able to process it fine. Then I setup a form in order to allow the client to upload the file. … | |
I'n trying to convert a dbf file to a csv file(or anything else really). I found this on the interwebs but I get an error import csv from dbfpy import dbf import sys dbf_fn = 'in.dbf' csv_fn = 'out.csv' in_db = dbf.Dbf(dbf_fn) out_csv = csv.writer(open(csv_fn, 'wb')) names = [] for … | |
hi, i have an import csv script but it does not get entered into the database. only "uploaded successfully" and the data is echoed but nothing in the database is something wrong with it? and is it sql injection safe? <?php if(isset($_SESSION['sess_user_id'])) { if (isset($_POST['ubmit'])) { require "connection.php"; $session = … | |
I have a python code that reads a specific folder for specific files. Once it finds a file that matches the re.split peramiters that it is given it then writes the data to a csv file. The issue is that for every file that it loops through and writes it … | |
I have a python script that reads a csv file and converts it to two new files so that my database can add new emails or update existing ones. What im trying to do now is after it has converted them for it to send me a email with how … | |
I have a very large csv file that had different values for certian fields and im wanting to split it up so that each of the different values gets put into its own csv file for example all of the fields whos value is 1110 would get read and written … | |
I have a python code that reads several csv files and writes teh data to a single file but every time it loops back around to the next file it prints the headers again. Is there a way to stop this I can post my code if it is nessisary. | |
I am trying to order by date DESC some events read from a CSV and print out them. The CSV file has to be read until it reaches the end and then order by date DESC only the entries in the following categories: champions and euro. This is the code … | |
I need to code a program to compare the datas in .csv file (.csv file is an excel file which will be seperated by , instead of cells by saving in.csv format). I've coded it fully and the required outout is also obtained. But i need a modified version of … | |
I am inserting the csv file into the database but it not inserting in proper way,the coloums are merged into each other,im not getting where im doing mistake .please help me in that my code`Inline <?php //database connection details $connect = mysql_connect('localhost','root','123456'); if (!$connect) { die('Could not connect to MySQL: … | |
Hi there. I was kinda researching on how I could store data at best (in my opinion). I came on "CSV" files. Which looked great to use. I found out there are two functions that can operate file. So I keep Googling on how to use the syntax and how … | |
using (StreamReader readFile = new StreamReader(filepath)) { string line; while ((line = readFile.ReadLine()) != null) { textBox1.Text = textBox1.Text + line + Environment.NewLine; } } This is what I have so far. I have tried using .Split to try to seperate them but do not know much about it. So … | |
So What I am trying to do it take a CSV file take what is in it and diplay it in a big textbox or txt file. String[] lines = File.ReadAllText("**").Split(','); foreach (string line in lines) { textBox1.Text = line; } That is what I have so far. Issues is … | |
I have a directory with hundreds of CSV files in it. Many of the files have synonyms for words that I no longer want. I want to replace all of the synonyms with approved words. For example some CSVs have synonyms like `vial` `jug` `canteen` `urn` etc and I want … | |
Good Afternoon. I've been sporatically researching this for weeks, but haven't been able to locate any 'CLEAR', 'PRECISE' direction on creating .csv files from a query of multiple tables. What I need to be able to do is gather the relavent information from the tables and combine it into a … | |
Hi All, I have an SSIS question regarding looping through CSV files with the Foreach Loop Container. What I have: 1. A string variable named fName - Global 2. A Foreach Loop Container 2.1 User::fName mapped to the loop container with an index of 0 3. A Data Flow Task … | |
I am trying to read a CSV file having no. of rows=row and no. of columns=col by the following method: public static String[][] FileIntoArray(int row, int col, String FileName){ int Filerow=0; int Filecol=0; String line; String[][] FileArray= new String[row][col]; File file = new File(FileName); try{ BufferedReader bf = new BufferedReader(new … | |
Hi All I'm sure I'm missing something very small - and embarrassing! I'm being lazy - I could have entered the data manually, but wanted to automate it. I have a small csv file containing swimming meets, dates and locations along the following lines: May-13;;;; 17;other;Level 1 Program 1;Arboretum; 24;other;All … | |
hello, my appreciating, if you give example code in my problem i have 1 file csv with dilimited only column A example column a name | address | phone | birthofdate deby | jersey | 123456 | 01-March-1990 my case is I want to convert to txt with delimited | … | |
Hi, All, I am just wondering is this is doable. I've tried searching it in google but still no luck. I want to merge my 2 CSV files by column. For example: File: coded.csv "Header A","Header B","Header C" "Data A","Data B","Data C" "Data A","Data B","Data C" "Data A","Data B","Data C" … | |
Hello, I'm currently working a project for class and I've gotten stuck. I am suppose to write a program that will read a csv file and create a text file with information from this csv file. So, far I have code that prompts for the file name and gives a … | |
Hello Everyone! I am a beginner user of Python without IT background (I am interested in IT developing my knowledge step by step). So far I did simple scripts in Python and I encountered a problem. I was looking on Google, however I didn't find the satisfactory answers which would … |
The End.