Splitting a string in javascript and storing in multidimentional array

Question

I have a string

string s='2011/01/03 00:00:00,14.00|2011/01/03 00:00:00,14.50|2011/01/03 00:00:00",15.00|2011/01/02 00:00:00,12.00|';

I want to split the string first by '|' , which i can do by using

var ds=[];
 ds=s.split('|');

i further want to split them by ',' and store in an array

The question is how do i store in a multidimention array so the output looks similar to this

da[0]={'2011/01/03 00:00:00',14.00}
da[1]={'2011/01/03 00:00:00',14.50}
.
.
.

Thanks Prady

If you really want a multi-dimensional array, see @patrickdw's answer for what the syntax looks like. Curly braces are for object literals (key/value pairs), not arrays (ordered values). — Phrogz
– Phrogz, Commented Jan 14, 2011 at 3:56
thanks Phrogz and patrick.. I was looking for an multidimentional array,, I had made a mistake by using the } instead of ] — Prady
– Prady, Commented Jan 14, 2011 at 4:08

user113716 · Accepted Answer · 2011-01-14 03:42:00Z

2

var ds = s.split('|');

for( var i = 0, len = ds.length; i < len; i++ ) {
    if( ds[i] )
        ds[i] = ds[i].split(',');
}

Result looks like:

[
  ['2011/01/03 00:00:00','14.00'],
  ['2011/01/03 00:00:00','14.50'],
  ['2011/01/03 00:00:00','15.00'],
  ['2011/01/02 00:00:00','12.00'],
  ''
]

answered Jan 14, 2011 at 3:42

user113716

323k64 gold badges454 silver badges441 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Phrogz Over a year ago

+1 for caching the length of the array, but -1 for multi-line statement without curly braces. :p

Phrogz · Accepted Answer · 2011-01-14 03:55:10Z

2

var s='2011/01/03 00:00:00,14.00|2011/01/03 00:00:00,14.50|2011/01/03 00:00:00,15.00|2011/01/02 00:00:00,12.00';
var pieces = s.split('|');
for (var i=0,len=pieces.length;i<len;++i){
  var pair = pieces[i].split(',');
  pieces[i] = {};
  pieces[i][pair[0]] = pair[1]*1; //*1 to convert from string to number
}

console.log(pieces);
// [
//   {'2011/01/03 00:00:00':14.00},
//   {'2011/01/03 00:00:00':14.50},
//   {'2011/01/03 00:00:00':15.00},
//   {'2011/01/02 00:00:00':12.00},
// ]

This is assuming, based on your pseudo-JS syntax using curly braces, that you really meant an array of objects instead of a multi-dimensional array. If you want a single object hashing 'time-as-string' to values, you might do:

var pieces = s.split('|');
var values = {};
for (var i=0,len=pieces.length;i<len;++i){
  var pair = pieces[i].split(',');
  values[pair[0]] = pair[1]*1;
}
console.log(values);
// {
//   '2011/01/03 00:00:00': 14.00,
//   '2011/01/03 00:00:00': 14.50,
//   '2011/01/03 00:00:00': 15.00,
//   '2011/01/02 00:00:00': 12.00,
// }

This would allow you to find the value for any given day in constant time, without traversing the array of values.

edited Jan 14, 2011 at 3:55

answered Jan 14, 2011 at 3:42

Phrogz

304k115 gold badges669 silver badges758 bronze badges

2 Comments

user113716 Over a year ago

I see you opted to interpret it as objects. You may be right. I'll give a +1 for that. :o) Oh, and for the number conversion as well. Good catch.

Phrogz Over a year ago

@patrickdw I suspect I'm not right; it makes little sense to have an array of objects with a single key each. I'll edit to add another possible guess, but I think you were right to go with the asked-for multidimensional array.

Collectives™ on Stack Overflow

Splitting a string in javascript and storing in multidimentional array

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related