Skip to content

Instantly share code, notes, and snippets.

@goofmint
Created January 11, 2012 04:51
Show Gist options
  • Select an option

  • Save goofmint/1593094 to your computer and use it in GitHub Desktop.

Select an option

Save goofmint/1593094 to your computer and use it in GitHub Desktop.
// Convert CSV data into array of arrays
jQuery.csv()("1,2,3\n4,5,6\n7,8,9\n"); // = [ [1,2,3], [4,5,6], [7,8,9] ]
// It handles quotes
jQuery.csv()('a,"b,c",d'); // = [ ['a', 'b,c', 'd'] ]
// You can use any delimiter, e.g. tab
jQuery.csv("\t")("a\tb\nc\td\n"); // = [ ['a','b'], ['c','d'] ]
// Quick usage with AJAX:
jQuery.get(csvfile, function(data) { array = jQuery.csv()(data); });
// Using across multiple files
var getTSV = jQuery.csv("\t");
jQuery.get(csvfile1, function(data) { array1 = getTSV(data); });
jQuery.get(csvfile2, function(data) { array2 = getTSV(data); });
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment