JavaScript str_getcsv
Parse a CSV string into an array
1 2 3 4 56 7 8 9 1011 12 13 14 1516 17 18 19 2021 22 23 24 2526 27 28 29 3031 32 | function str_getcsv ( input, delimiter, enclosure, escape ) { // Parse a CSV string into an array // // version: 909.322 // discuss at: http://phpjs.org/functions/str_getcsv // + original by: Brett Zamir (http://brett-zamir.me) // * example 1: str_getcsv('"abc", "def", "ghi"'); // * returns 1: ['abc', 'def', 'ghi'] var output = []; var backwards = function (str) { // We need to go backwards to simulate negative look-behind (don't split on //an escaped enclosure even if followed by the delimiter and another enclosure mark) return str.split('').reverse().join(''); }; var pq = function (str) { // preg_quote() return (str+'').replace(/([\\\.\+\*\?\[\^\]\$\(\)\{\}\=\!\<\>\|\:])/g, "\\$1"); }; delimiter = delimiter || ','; enclosure = enclosure || '"'; escape = escape || '\\'; input = input.replace(new RegExp('^\\s*'+pq(enclosure)), '').replace(new RegExp(pq(enclosure)+'\\s*$'), ''); // PHP behavior may differ by including whitespace even outside of the enclosure input = backwards(input).split(new RegExp(pq(enclosure)+'\\s*'+pq(delimiter)+'\\s*'+pq(enclosure)+'(?!'+pq(escape)+')', 'g')).reverse(); for (var i = 0; i < input.length; i++) { output.push(backwards(input[i]).replace(new RegExp(pq(escape)+pq(enclosure), 'g'), enclosure)); } return output; } |
Examples
Running
1 | str_getcsv('"abc", "def", "ghi"'); |
Should return
1 | ['abc', 'def', 'ghi'] |
Dependencies
No dependencies, you can use this function standalone.
Open syntax issues
php.js uses JsLint to help us keep our code consistent and prevent some common bugs.
Eventually we want all code to pass or at least take into consideration most fixes suggested by JsLint, following this JsLint configuration we’ve decided on.
Authors
Thanks to the following developers, you get to have str_getcsv goodness in JavaScript.
No comments yet. Be the first!
spread the word:
Use any PHP function in JavaScript
These kind folks have already donated: Anonymous and Shawn Houser.
<your name here>