[csv] Forum Topics

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 …

I am trying to decrypt a CSV using Coldfusion. The CSV has been encrypted using gpg4win. I have created a scheduled task in CF Admin which checks a folder for the encrypted file and if found, decrypts it and stores the result in another folder as a CSV file (Which …

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 …

I have a csv file with lines like this example: 14," APPLES, GRANNY SMITH 72 CT usa, Case",101-016,40.00,7/16/2013,7/22/2013 14," APPLES, GRANNY SMITH 72 CT, Each",010-017,0.60,7/16/2013,7/22/2013 I need to do a few things here - I need to remove any surrounding quotes from around fields; I also need to split the …

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 not able to insert data from CSV file with "¤" Character. Please help me to solve the problem. Thanks a lot in advanced. CSV File: FirstName¤LastName¤City¤Year |$| Bill¤Gates¤NW¤2013¤|$| David¤Beckham¤London¤2010¤|$| PHP Code: $csv_file = "Contacts.csv"; $csvfile = fopen($csv_file, 'r'); $theData = fgets($csvfile); $i = 1; do { $insert_csv = …

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 …

**I am trying to read the records from and to a CSV file in C. Of course i want to stop when I have read all the records. If I use a for loop it works perfect except I have to know how many records there are. if I change …

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 I'm new to Python and have the following problem. I have a excel file (csv format) that I want to open and display as a 2d list. I can read the file but can not get anyother output other than the colum headings as a single letter [h][e][a][d][i][n][g] I …

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" …

Hi, I have a csv file that looks like this: Date, Cost Jan 12, 23.2 Feb 2, 45.3 May 4, 33.4 March 3, 32 May 9, 21 July 22, 332 Aug 3, 765 I am using scanner to read the file and can do that with no issues. Howevet, I …

I am using a java program to read lines from csv and insert them into mysql database. Whenever i run my program i discovered i could not insert values into a date field insert mysql if the value comming from the file is null. However if i change the field …

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 …

Hi I have data in the following format that I need to write to a csv file. Student1 Mark1 Mark2 Mark3 Mark4 Mark5 Student2 Mark1 Mark2 Mark3 Mark4 Mark5 Student3 Mark1 Mark2 Mark3 Mark4 Mark5 Student4 Mark1 Mark2 Mark3 Mark4 Mark5 Student5 Mark1 Mark2 Mark3 Mark4 Mark5 I am writing …

Good Day, I have a text file in the .csv format. The file originates as a xlsx (excel) file type. The file looks something like the following. Name Number Lat Long Jan Feb Mar Apr Brockton 24-1670-06 38.145236 145.854921 0.15 0.62 1.25 2.14 Westby 24-7432-04 35.846125 132.743652 0.25 0.94 1.14 …

Hello, I have a CSV file that has a dynamic number of columns and rows. I would like for each value in a row to be in an array and then that row to be in an array therefore creating a multidimensional array. I need this done in ASP. I …

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 …

Hi all, I am trying to use the following python code to read data from two .csv files which have data in the following format, e.g. 1, 23.27, 23.21, 83.22 2, 34.25, 65.31, 34.75 ... etc I seem to be getting an error around during execution of the function. I …

Hello everyone, I need some help, I would like to merge two cells together within a row only (e.g) in a CSV file using python. So far, I have 4 columns in the file, but now I would like to merge two cells in one, but I don't have any …

I have a flat file (template) where I want to replace variables based upon value in another file (csv). Variables in them template are named %VAR_Xz% The values are in the csv file and X is field 0 of each line and y field 1 and up. Example: Badidas, 13.00, …

Is there a way to read in a two-columned CSV file, and based on the fields in 1st column, output many different files? The input/output looks something like: input.csv call Call Mom. call Call T-Mobile. go Go home. go Go to school. go Go to gas station. play Play music. …

Hi All, In my opinion, this is the best way to read in text from a csv file. Take for example if you are importing addresses: "1 Main Street","SmallTown","SmallCounty" The above is fine and easy to parse in BUT what if an address like this was entered: "App 1A, Tall …

Trying to go thru the contents of a table with the following layout indexfield1,art1,art2,art3,art4 In this table indexfield and art1 are always filled art2, art3, and art4 can be empty. In pseudo-code this is what I want to do: for each art of table where indexfield = x: do bladibla …

Hi, I have quite a large CSV file (Around 20,000 rows with about 20 columns) that I am trying to manipulate. Initially I am looking for a way to get out the first 10 or so records after they have been sorted in ascending order on one of the numeric …

When trying to load csv file data into Scribus it only takes the data of the last row. I'm using ScribusGenerator.py by Ekkehard Will and my best guess is that the cause of the problem is somewhere in this part of the code: def replaceVariablesWithCsvData(self, headerRow, row, lines): # lines …

Hi All, I am a newbie programmer in python and I am trying to read multiple csv files from a folder, perform some data sums based on timestamps for each row for all the csv files and then output the sums to one result csv file. So far I am …

Here is part of the html <body> <table> <tr> <td id="ctl00_ContentPlaceHolder1_TD_Unlimited_Usage_PerDay" class="form_label" colspan="2"> <table width='100%' cellspacing='2' cellpadding='0' border='0'> <tbody> <tr> <td align='center' bgcolor='#E1E1E1'>Date</td> <td align='center' bgcolor='#E1E1E1'>Download Usage</td> <td align='center' bgcolor='#E1E1E1'>Upload Usage</td> <td align='center' bgcolor='#E1E1E1'>Total Usage</td> </tr> <tr> <td class='table_item' align='center' bgcolor='#EBEBEB'>2012-11-02</td> <td class='table_item' align='center' bgcolor='#EBEBEB'>1.269 GB</td> <td class='table_item' align='center' bgcolor='#EBEBEB'>0.286 …

How do I display whatever that gets submitted in a CSV File on an HTML Web Page by pulling it with php... I am kind of lost....?