How to open CSV file with VBA macro
I have CSV file and Macro in VBA. I want to open CSV file in Excel and automatically launch a macro which creates a chart. Is it possible? How to do this (Using language: Java)? ...
csv
Can I build a resulset from a file in Java?
I don't have much experience working with resultsets, but as ResultSet is an interface, I guess I could implement it to work with a file as a backend. Is this nonsense? Is there any solution already given for my problem? ...
Writing a CSV file for Mac users with PHP
I use a generic algorithm to write CSV files that in theory works for the major OSes. However, the client started to use Mac a few weeks ago, and they keep telling me the CSV file cannot be read in Microsoft Excel 2008 for Mac 12.2.1. They have their OS configured to use "semicolon ;" as list separator, which is exactly what I am writin...
Get In That DB! Parsing CSV Using Ruby...
I have a CSV file formatted just like this: name,color,tasty,qty apple,red,true,3 orange,orange,false,4 pear,greenish-yellowish,true,1 As you can see, each column in the Ruby OO world represents a mix of types -- string, string, boolean, int. Now, ultimately, I want to parse each line in the file, determine the appropriate type, and ...
extracting only unique row from csv based on multiple column criteria ?
basically i have rows after rows of data event | venue | date | some | other | columns | here| there are lot of overlapping event that happens at same venue and date. so i would like to end up with only unique events by matching event, venue, date. is this possible in excel , how to approach this ? VBA ? or some option i dont know ab...
regex to parse csv
I'm looking for a regex that will parse a line at a time from a csv file. basically, what string.readline() does, but it will allow line breaks if they are within double quotes. or is there an easier way to do this? ...
Scrape HTML tables from a given URL into CSV
I seek a tool that can be run on the command line like so: tablescrape 'http://someURL.foo.com' [n] If n is not specified and there's more than one HTML table on the page, it should summarize them (header row, total number of rows) in a numbered list. If n is specified or if there's only one table, it should parse the table and spit i...
Working with a CSV file with odd encapsulation // PHP
I have a CSV file that I'm working with, and all the fields are comma separated. But some of the fields themselves, contain commas. In the raw CSV file, the fields that contain commas, are encapsulated with quotes, as seen here; "Doctor Such and Such, Medical Center","555 Scruff McGruff, Suite 103, Chicago IL 60652",(555) 555-5555,,,,so...
How to get the number of columns from a JDBC Resultset?
I am using CsvJdbc (it is a JDBC-driver for csv-files) to access a csv-file. I don't know how many columns the csv-file contains. How can I get the number of columns? Is there any JDBC-function for this? I can not find any methods for this in java.sql.Resultset. For acessing the file, I use code similar to the example on the CsvJdbc web...
Processing CSV File
I am using Sebastien LorionReference CSV reader to process my CSV file in C# 3.0. Say example id|name|dob (Header) 1|sss|19700101 (data) 2|xx|19700201 (data) My Business Object is class Employee { public string ID {get;set;} public string Name {get;set;} public string Dob {get;set;} } I read the CSV stream and stored i...
Groovy load .csv files
Hi all, How to read and import .csv file in groovy on grails. I have .csv file with data and need to import in to db using user interface . thanks in advance, srinath ...
define keys in multidimensional array from csv
I want to compare two arrays, one coming from a shoppingcart and the other one parsed from a csv-file. The array from the shopping cart looks like this: Array ( [0] => Array ( [id] => 7 [qty] => 1 [price] => 07.39 [name] => walkthebridge [subtotal] => 7.39 )...
how to convert html to csv ?
is there a html parser or some library that automatically converts html page into csv data rows ? ...
Reading numeric Date value from CSV file to data.frame in "R"
> D <- read.csv("sample1.csv", header = FALSE, sep = ",") > D V1 V2 V3 V4 1 20100316 109825 352120 239065 2 20100317 108625 352020 239000 3 20100318 109125 352324 241065 > D[,1] [1] 20100316 20100317 20100318 In the above example how do I get the data in D[,1] to be read, and stored as date values: 2010-03-16, 201...
Read alphanumeric characters from csv file in C#
I am using the following code to read my csv file: public DataTable ParseCSV(string path) { if (!File.Exists(path)) return null; string full = Path.GetFullPath(path); string file = Path.GetFileName(full); string dir = Path.GetDirectoryName(full); //create the "database" connectio...
How to Import a CSV file containing multiple sections into R?
I want to import the contents of a csv file into R, the csv file contains multiple sections of data vertically, seperated by blank lines and asterisks. For example ******************************************************** * SAMPLE DATA ****************************************** ******************************************************** Na...
Excel VBA: importing CSV with dates as dd/mm/yyyy
ello I understand this is a fairly common problem, but I'm yet to find a reliable solution. I have data in a csv file with the first column formatted dd/mm/yyyy. When I open it with Workbooks.OpenText it defaults to mm/dd/yyyy until it figures out that what it thinks is the month exceeds 12, then reverts to dd/mm/yyyy. This is my test...
Muslim Hadeeth Database / CHM to CSV or SQL
I am looking here to create a Facebook App on Hadeeth. My first question is for muslim programmers here because other might not be having clue. Is it possible to find hadeeth in csv / sql (at least the popular ones like bukhari, muslim, tirmidhi) otherwise Do we have any tools or is it possible to convert CHM files into CSV or SQL ? T...
Spooling data to CSV truncates
Hi, I am using the below script to output data to a csv file: set heading off set linesize 10000 set pagesize 0 set echo off set verify off spool D:\OVERNIGHT\TEMP_FILES\PFRA_DETAIL_VIXEN_OUTPUT.txt SELECT TRIM(T4.S_ORG_ID)||','|| TRIM(T4.NAME)||','|| TRIM(T3.CREATION_TIME)||','|| TRIM(T5.X_HOUSE_NUMBER)||','|| TRIM(T5.X_FLAT_NUMBER...
C# Importing Large Volume of Data from CSV to Database
What's the most efficient method to load large volumes of data from CSV (3 million + rows) to a database. The data needs to be formatted(e.g. name column needs to be split into first name and last name, etc.) I need to do this in a efficiently as possible i.e. time constraints I am siding with the option of reading, transforming an...