Parsing CSV data in Javascript

Question

I have a string like this:

138374:order1,738437:order2,927438:order3

I am doing a loop to split orders by comma (,)

How do I split it further by colon(:) to yield the order number and order name.

Below is the code:

function(getOrders) {
  var completeOrderRequest = getOrders.split(',');
  for(var j=0; j < orderRequest.split(',').length; j++) {
    alert(completeOrderRequest[j]);
    var nameOrderIds = completeOrderRequest[j].split(':');

    alert("OrderNumber: "+nameOrderIds[0]);
    alert("Name : "+nameOrderIds[1]);
  }  
}

Right now its giving me orderNumber 0.

related: [How can I parse a CSV string with Javascript?](http://stackoverflow.com/questions/8493195/how-can-i-parse-a-csv-string-with-javascript), [Javascript code to parse CSV data](http://stackoverflow.com/questions/1293147/javascript-code-to-parse-csv-data) — Bergi, Feb 21 '13 at 19:38

score 0 · Answer 1 · answered Jun 18 '10 at 18:33

function getOrders( orderString) {
   var orders = orderString.split(','); // create array of ordernumber:name combos
   for( var i=0; i < orders.length; i++) { // use length of above array, not a split again
      var entry = orders[i].split(':'); // now break each combo into it's own array
      alert( "OrderNumber: " + entry[0] );
      alert( "Name: " + entry[1] );
   }
}

demo: http://jsfiddle.net/MDNmF/

score 0 · Answer 2 · answered Jun 18 '10 at 18:34

Here is a function that should be more like what you're looking for:

function(getOrders) {
  var completeOrderRequest = getOrders.split(',');
  for(var j=0; j < completeOrderRequest.length; j++) {
    var idsAndNames = completeOrderRequest[j].split(':');
    alert("OrderNumber: "+idsAndNames[0]);
    alert("Name : "+idsAndNames[1]);
  } 
}

score 0 · Answer 3 · answered Jun 18 '10 at 18:34

Where is the orderRequest in the orderRequest.split(',') coming from?? should this be instead:

for (var j = 0; j < completeOrderRequest.split(',').length; j++)

If so, that means you are doing a split twice, which would not work because you are splitting on the same character.

score 0 · Answer 4 · answered Jun 18 '10 at 18:35

what is orderRequest?

var getOrders = "138374:order1,738437:order2,927438:order3,";

var completeOrderRequest = getOrders.split(",");

for(i = 0; i < completOrderRequest.length; i++){
   var nameOrderIds = completeOrderRequest[j].split(':');
   alert("OrderNumber: "+nameOrderIds[0]);  
   alert("Name : "+nameOrderIds[1]);    
}

score 0 · Answer 5 · edited May 23 '17 at 11:55

0

Be aware of var hoisting. Javascript doesn't have block-scope variables, only function-scope ones; in your code, nameorderIDs is actually defined just below completeOrderRequest.

edited May 23 '17 at 11:55

Community

1
1

answered Jun 18 '10 at 18:36

Dan Davies Brackett

9,811
2
32
54

Parsing CSV data in Javascript

5 Answers5