Snipplr

(C#) Convert object array TO or FROM CSV text - danh955

Tue, 25 Oct 2016 05:32:32 UTC

The Export function will convert an array of objects into a single CSV string. The Import function will read from a TextReader that has CSV data and convert one data row to an array of strings. Each time this is called, it will convert another data row.

(Visual Basic) Access (VBA) Import CSV files into database - cueballrawn

Fri, 22 Jul 2016 19:53:19 UTC

Import CSV files into a named table in Access database. Use to bulk load tables.

(Ruby) Turn CSV With Headers Into Array Of Hashes - legrandkay

Wed, 12 Feb 2014 19:57:36 UTC

To be improved to work with fasterCSV

(Bash) Convert list to " protected CSV - johngh

Wed, 13 Nov 2013 04:41:00 UTC

Convert a listing to quote protected CSV

(SQL) Bulk insert/upload microsoft sql server (csv) - dego89

Fri, 17 May 2013 04:03:48 UTC

Bulk upload a CSV into Microsoft SQL Server

(C#) Convert Excel file (XLS) to CSV - engebaja

Wed, 08 May 2013 16:54:17 UTC

Convert Excel file (XLS) to CSV

(PHP) CSV(unicode) file to php array - hgc81538

Tue, 28 Aug 2012 13:46:15 UTC

CSV(unicode) file to php array

(PHP) CSV handler class - TimoZachi

Tue, 21 Aug 2012 04:53:02 UTC

Class that convert arrays to csv format, downloads CSV files and saves to disk on server.

(DOS Batch) Combine/append ASCII files using DOS - webonomic

Fri, 13 Apr 2012 00:53:33 UTC

Quickly combine/append ascii type files such as txt or csv.

(Other) ISO 3166-1 alpha-2 CSV - freezy

Fri, 04 Nov 2011 04:54:40 UTC

ISO 3166-1 alpha-2 in csv format

(PHP) Check Supplier and If Active - terataz

Sat, 01 Oct 2011 03:25:10 UTC

(PHP) Simple MySQL to CSV - FatFolderDesigner

Sat, 03 Sep 2011 11:34:22 UTC

Just a short little script that takes a mysql query and turns it into a csv file that downloads automatically. If your interested in the details you can hit up the link.

(PHP) PHP Read CSV to Array - iloveitaly

Wed, 24 Aug 2011 22:02:38 UTC

(Java) Writing a CSV file with Java using OpenCSV - m1b

Fri, 19 Aug 2011 06:36:27 UTC

(Ruby) Ruby CSV writing and reading example with quotes, line breaks and commas in the fields - m1b

Fri, 19 Aug 2011 05:51:04 UTC

Shows how to read/write fully formatted CSV with Ruby

(Python) Read a csv file - ronakpatel2006

Thu, 11 Aug 2011 11:11:26 UTC

(Ruby) Ruby: CSV to XML (Version 2) - chrisaiv

Mon, 18 Jul 2011 05:33:51 UTC

I use this code snippet all the time. It allows me to parse a CSV file and transform it into an XML file.

(Python) Magento Missing Order Finder - eristoddle

Thu, 30 Jun 2011 05:03:01 UTC

(Python) Python CSV Row to Object - eristoddle

Thu, 30 Jun 2011 01:23:05 UTC

(Bash) Sed and Awk CSV Address Prep - johnattebury

Mon, 27 Jun 2011 16:23:54 UTC

(Bash) CSV to TSV with tr - jeremydouglass

Mon, 25 Apr 2011 04:27:48 UTC

(Bash) CSV to TSV with sed - jeremydouglass

Mon, 25 Apr 2011 04:19:51 UTC

(Python) CSV reading in python - magicrebirth

Tue, 22 Mar 2011 22:23:48 UTC

(Python) Basic class to parse variable field CSV files. - mattsn0w

Sat, 19 Mar 2011 10:05:26 UTC

(Perl) Text::CSV by hashref - alfirth

Fri, 04 Mar 2011 07:31:46 UTC

(PHP) Save persons as csv example - jorisros

Fri, 18 Feb 2011 00:47:17 UTC

(PHP) Export MYSQL to EXCEL / CSV via PHP - kidmizere

Sun, 09 Jan 2011 10:04:41 UTC

Modify includes to connect and select to provide correct result set

(Python) Convert CSV file to Pipe Delineated File - jachin

Wed, 15 Dec 2010 08:43:16 UTC

(Ruby) Ruby: Importing CSV data into DB with ActiveRecord Validation - chrisaiv

Sat, 23 Oct 2010 08:44:17 UTC

This script is a nice balance between validating data and speed.

(C#) Simple CSV Writer - hoffstein

Tue, 05 Oct 2010 07:19:51 UTC

(Bash) Split large CSV file in several files - eme_dlr

Tue, 14 Sep 2010 21:57:36 UTC

(PHP) How to use Google HTTP Geocoding - adampatterson

Thu, 09 Sep 2010 01:59:08 UTC

(PHP) CakePHP CSV export Controller - damanlovett

Fri, 20 Aug 2010 01:15:39 UTC

(PHP) Simple CSV Reader - Sverri

Tue, 17 Aug 2010 14:31:09 UTC

See code comments for more details.

(SQL) mysql query to populate table from data in file - breign

Wed, 30 Jun 2010 00:37:47 UTC

(Perl) csv2xml perl version - bionic

Wed, 03 Mar 2010 18:16:30 UTC

Useful perl snippet to convert csv docs to xml from Ankh on the freenode #xml irc channel

(PHP) MySQLi convert a result set to CSV or to JSON - ginoplusio

Mon, 01 Feb 2010 05:45:29 UTC

(Other) Export a Single Sheet of an Excel Spreadsheet as CSV from the Command Line with Open Office - softmechanics

Fri, 29 Jan 2010 20:28:06 UTC

modified from branflake2267's post at oooforum.org: http://www.oooforum.org/forum/viewtopic.phtml?t=52942 usage: Paste into the Standard.Module1 macro file. Then, create xls2csv bash script containing: #!/bin/bash file="$(readlink -f "$1")" /usr/lib/openoffice/program/soffice -invisible -headless -norestore "macro:///Standard.Module1.ConvertXls2Csv(\"$file\", \"$2\")" The first argument is the xls file name, second is the name of the sheet: `xls2csv ./spreadsheet.xls "Some Sheet"`

(Bash) Linux convert file encoding - bionic

Fri, 22 Jan 2010 05:39:39 UTC

To convert files, especially prior to mysql insert. use file filename to find out encoding

(MySQL) Date formatting with LOAD DATA INFILE - j4kp07

Thu, 10 Dec 2009 15:18:19 UTC

Came across this nice snippet @ mysql.com

(PHP) batch import csv to drupal database - ReeceMarsland

Mon, 30 Nov 2009 09:48:02 UTC

(MySQL) MySQL REGEX match comma-delimitted list - j4kp07

Mon, 02 Nov 2009 15:40:18 UTC

(Other) Import Export CSV routine for CakePHP - welly

Mon, 06 Jul 2009 18:48:57 UTC

(PHP) reading CSV file with PHP - antpaw

Mon, 22 Jun 2009 07:04:42 UTC

this script splits the csv file two times (1. on "new line", 2. on ";") and returns a two dem array in the last for loop.

(Python) CSV example for working with myIO - cthulhupunk0

Mon, 08 Jun 2009 12:37:02 UTC

(Python) Generic superclass for dealing with io based tables - cthulhupunk0

Mon, 08 Jun 2009 12:35:58 UTC

(PHP) Hypo CSV crawler - online banking statements downloader from Hypovereinsbank Munich, Germany using PHP & CURL CLI - uioreanu

Sun, 15 Mar 2009 15:12:35 UTC

updated 2013-04-18! just replace the XXX fields with your own numbers. Then run this PHP Script from the command line (CLI mode). It will fetch the online statements from Hypovereinsbank direct banking. The code works by tweaking CURL settings around the HTTPS connection.

(PHP) Export data to CSV - fackz

Thu, 05 Mar 2009 10:03:05 UTC

The best part about this script is that any table you put in the query on line 14 will be the headers and data in the CSV. No need to hand type out all the table headers unless you want to comment that section out and put in your own. So if you have a table full of users that includes: name, email, website, phone you could create a query like: SELECT name, email, website, phone FROM users This would pull only those fields to the CSV if you had other data like passwords, nicknames or instant messenger addresses in the same table.

(ASP) Delete Last Comma - jlvallelonga

Tue, 10 Feb 2009 12:08:29 UTC

This function takes a string and deletes the last comma in it. It is meant for strings with a trailing comma such as "13, 24, 15, "

(PHP) Export MySQL Data as CSV - mikegreen

Thu, 15 Jan 2009 00:09:34 UTC

# Export MySQL Data as CSV This code takes a `mysql_query()` resource and outputs its rows into CSV spreadsheet format. Edit the `header('Content-Disposition...` declaration to tell the user's browser to either display the data as plain text or download it as an `attachment`. __Note:__ This doesn't include the code to connect to the database in the first place. Don't forget that, otherwise this code is pretty useless.