[csv] Forum Topics

hey guys! how do i calculate the sum of a column in .csv file format using C? e.g my fie looks like this 1, 2, 3, 4 2, 3, 4, 5 3, 4, 5, 6 (the ',' shows new cell) how do i calculate sum of each column (desired answer …

Hi guys im having a lot of problems trying to code. I have opened a csv file and have read it using strings.I have splitted the strings by the ','. I want to load each of these values into a 2 dimensional array! but im having problems. Ultimatly i want …

Ok so let me start off by saying I am not a NOOB. There... So i need help trying to figure out an export of just my 2 colums from a table. Got it done. Now i need to make sure that I only export from a date range and …

What I'm trying to do is parse a CSV file that has column headers, and map those headers - ideally to a class. The tricky part is that I need to be able to support various mappings because it will be interacting with different systems that give the headers different …

hello friends, I have generated a csv file with 27 columns. third column is of time and i want to sort all the data according to this column in ascending order. so can you please tell me how to do this.? i have no clue where i should start. i …

hello all, following is the code that fetches required columns from r.csv and makes a new file. now i want to ignore first line of r.csv while fetching defined column . what should be done? [CODE] #include <stdio.h> #include <stdlib.h> int main() { FILE *in, *out; char ch; char *rdf,*wdf; …

hi every one i want to ask is there any way through which i can retrieve column number of csv file using c programming. those number which are by default set in cvs file also the row name i-e A B C.............. Z AA AB AC........... thanks in advance

I want to convert a kind of a large MSSQL table to text -- ideally CSV. One crude way would be to use SQL Developer to do a SELECT * and do a copy-and-paste. But there must be a more precise and efficient way of doing this. Perhaps SQL Developer …

i have a program in c language that reads csv file.. now i want to read data column wise.. i want the whole program..which will take file name as command line argument and will fetch second column from the file.. lets assume file is like below.. aggromat,"1","abc","8903" aggromat,"2","abc","ddds" reply as …

Hopefully someone can help me. Explaining this may be a pain for ya, but I would really appreciate any assistance that you may be able to give me. Here is my scenario. -I am trying to import a csv file into phpmyadmin. -The MySQL database is for Wordpress. -The .csv …

I have a database, that has a type_code in it. There are 3 types of products and certain numbers and costs associated with each type. The type codes are not present in sequential order in the database. they are random and i have a csv file with only 2 columns …

I have a CSV with a large number of rows and 7 columns. I get the data from another source and it is labeled as say Column 1 is first name, 2 is last, 3 is age, 4 is gender, 5 is city. I need to be able to scan …

Hello, I was wondering if anyone could help me with something. I am not a programmer yet I am able to modify scripts to a certain extent. I recently downloaded a script to read an existing CSV file and output via an SSI call. What I would like to do …

Hi All, I have a small problem that I am trying to solve...It regards storing string values in an array and outputting them to a .csv file. As you know the .csv file accepts inputs delimeted by commas ",", however the arrayed values are also delimeted by commas therefore $arr[$i]="1,2,3"; …

Hello guys, I'm quite new to C++, I'm trying to achieve a task whereby i could read from a csv file and write to that same file and vice versa depending on the user's selection. This is what i did: [B]Here's the data already on file[/B] 1,Mickey,23,090,Girne,TRNC,465 2,Charles,23,090,Girne,TRNC,465 3,Species,23,090,Girne,TRNC,465 4,Moody,23,090,Girne,TRNC,465 …

I have a unit conversion program that needs to take in a float and 2 strings from standard input. My previous solution was: [CODE] float orig_quant; char *orig_name = (char*) malloc(MAX_CHARS); char *new_name = (char*) malloc(MAX_CHARS); fscanf(stdin, "%f %s %s", &orig_quant, orig_name, new_name); [/CODE] However, this only works if the …

Hi everyone, I have a very large CSV file. 51427 lines to be exact. I need to import the entire file into a MySQL database, however, the script times out due to server settings and slow connection (and maybe other reasons that I am not aware of). So - I …

Hi im desperately in need of some help here.. Im exporting my html page data to csv but i am unable to get the data onto a new column the code is as follows [B][COLOR="Red"]HTML FORM[/COLOR][/B] [CODE]<form id="form1" name="form1" method="post" action="index.php"> <table class="formatTblClass"> <tr> <th colspan="6"><?=$message;?></th> </tr> <tr> <td width="68"><span>First …

i have a csv file from where in i read the data and store individual coloumns in list , but for the last coloumn i am getting \n in the list . i want to get rid of that . [CODE] f = open('datagen.txt') for lines in f: line = …

Hi everyone.. I'm new to python, the more to matplotlib :( and I am hoping that I can get help from this community... :) I have a .csv file, first column is a time stamp with format HH:MM:SS, next 8 columns are values of different parameters. I want to plot …

Hello, I have been attempting to export fields from an acesss query to a csv file. In each case the first time I export the file everything is perfect. However when I go to recreate the export (using the same query) the memo field is suddenly truncated. Any idea why …

I'm working with VB.Net. I have imported some data into the Data Set. I have four columns of data. [CODE] [Column 1]This is a test[/Column 1] [Column 2]This is a comma, Test.[/Column 2] [Column 3]This is a double quote " test.[/Column 3] [Column 4]This is a comma, quote " test.[/Column …

Hi all, I'm developing a graphing application that plots several lines from a protein sequencer that outputs its values in .csv format. I've read the csv into a DataGridView just fine, which is laid out like this: Cycle | A1 | A2 | A3 (all the way up to A12, …

I am trying to write a program that will read values from spreadsheets and stuff and I know I need to use CSV files instead of Excel files and stuff, but say I want to just read a single entry at a specific coordinate how do I access that one …

[B]Background: [/B] I'm extracting values from a file which is sometimes an xls and sometimes an xlsx file. An xls is easily read with xlrd, but xlrd nor any other Python library (as far as I could find) supports xlsx, so instead I'm using[URL="http://github.com/dilshod/xlsx2csv"] xlsx2csv[/URL] to convert to csv and …

hi! does anyone know how to convert excel file (xls and xlsx)(or even just xls) into csv preferably using xlrd and csv modules. i need to convert a specific excel sheet to csv. i need to create a csv file instead of using comma but semicolon. i am still not …

Here is a free excel to tab file convertor. Feel free to use for whatever purpose you want. There is no need for excel to be installed on the host pc. Assumes the user is on a windows platform. Extract all three files into one folder and run the main …

Hi, First off, I'm a real greenhorn so please forgive me asking questions which may be bleeding obvious, but I have searched and searched and cannot find an answer to my problem. I'm trying to import a CSV file into sqlite3 database in python. The CSV file has 56 columns …

Hi all, I'm trying to set up code that will allow me to do the following: Read in a csv file, In columns 3 and 5 there is similar information, I want to count how many times each unique entry is in either of these columns. For example: col 3: …

Hello all. I am very new to VB.Net and am currently learning the basics and mechanics of how the software functions, my past was mainly with Matlab, so naming variables and such is quite different to me now. My question is this: How can I read data from a .csv …