Parsing CSV file without standard delimiter

Question

I'm new to JavaScript and jQuery. I'm trying to parse CSV file where delimiter is not standard sign of comma (,), but something else(;).

I'm using the jQuery function $.csv.toArrays(csv, options, callback). I'm aware that delimiter is supposed to be set in options, but I'm having hard time figuring how exactly to do this.

Thank you very much.

What is `$.csv`? Do you have a link to that plugin? Did you read its documentation? — gen_Eric, Mar 25 '14 at 16:19
@RocketHazmat Link to docs http://github.com/evanplaice/jquery-csv — Evan Plaice, Jan 21 '16 at 12:31

score 4 · Accepted Answer · edited Jan 21 '16 at 12:35

4

Try with:

var options={"separator" : ";"};
$.csv.toArrays(csv, options);

edited Jan 21 '16 at 12:35

Evan Plaice

13,944
6
76
94

answered Mar 25 '14 at 16:25

juvian

15,875
2
37
38

FYI, the callback us optional unless you need to specify a callback function to run after the parsing is complete. – Evan Plaice Jan 21 '16 at 12:36

score 2 · Answer 2 · edited Jan 21 '16 at 12:34

2

According to the documentation you can override the delimiter in the options object like this:

$.csv.toArrays(csv, {'separator':';'}, callback);

edited Jan 21 '16 at 12:34

Evan Plaice

13,944
6
76
94

answered Mar 25 '14 at 16:26

Reeno

5,720
11
37
50

score 0 · Answer 3 · edited Jan 21 '16 at 12:37

0

Assuming you're referring to jquery-csv, then according to the documentation available here you need to use the following:

$.csv.toArrays(csv, { separator: ';' });

edited Jan 21 '16 at 12:37

Evan Plaice

13,944
6
76
94

answered Mar 25 '14 at 16:25

Phylogenesis

7,775
19
27

score 0 · Answer 4 · answered Mar 25 '14 at 16:26

var csv = "Joe;23;USA\n" + 
          "Attila;24;Hungary\n" + 
          "Li;20;China",
    options = { separator: ";" };

$.csv.toArrays(csv, options, function(err, data){
    console.log(data);
});

The data argument of the callback will be an array of arrays:

[["Joe","23","USA"],["Attila","24","Hungary"],["Li","20","China"]]

Here is the jsfiddle.

Parsing CSV file without standard delimiter

4 Answers4