Welcome To Snipplr


Everyone's Recent Snippets Tagged csv



3 536 posted 12 years ago by damanlovett
See code comments for more details.
1 414 posted 12 years ago by Sverri
Useful perl snippet to convert csv docs to xml from Ankh on the freenode #xml irc channel
0 366 posted 12 years ago by bionic
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 -...
0 787 posted 12 years ago by softmechanics
To convert files, especially prior to mysql insert. use file filename to find out encoding
1 443 posted 12 years ago by bionic
Came across this nice snippet @ mysql.com
2 1818 posted 12 years ago by j4kp07
4 555 posted 13 years ago by welly
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.
2 428 posted 13 years ago by antpaw
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...
0 862 posted 13 years ago by uioreanu
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...
2 547 posted 13 years ago by fackz
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, "
1 659 posted 13 years ago by jlvallelonga
# 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 do...
6 533 posted 13 years ago by mikegreen
Imports data from CSV (excel-compatible format) into MySQL. Also check the mysqlimport utility and the complementary SELECT ... INTO OUTFILE.
4 628 posted 14 years ago by jarnaldich
1 471 posted 14 years ago by mikegreen
0 388 posted 14 years ago by benpjohnson
0 370 posted 14 years ago by iTony
2 744 posted 14 years ago by Abe
fill your username and password
0 481 posted 14 years ago by eszpee
1 569 posted 14 years ago by Abe
1 358 posted 15 years ago by sjtai
13 967 posted 15 years ago by johnself
This example demonstrates usage of Scriptella ETL Tool to load CSV data into a database table.
3 703 posted 15 years ago by ejboy
I think I got this one off php.net. I wish I could thank the author properly because this has been a real helper!
11 570 posted 15 years ago by koncept
This is an example of how to use the articleHandler.class.php , this class can be found @ pietervp.com -> downloads
1 385 posted 15 years ago by pietervp