JavaScript - get csv column values

Question

How can I get the individual values from the value variable below which gives me a string like this: 1001,10/01/2016,11/01/2016 and assign to each of my variable after the value?

var lines = loadedString.split('\n'); //split on newlines
	for (var i = 0; i < lines.length; i++)
	{
		var value = lines[i].split('\t');
		var id;
		var start;
		var end;
	}

Your code is looking reasonable, except that you're not splitting each line on the right character. Your separator appears to be a comma, not a tab. — Robert Harvey
– Robert Harvey, Commented Jan 11, 2017 at 0:04
if you're doing split('\t') that sounds like a tsv not a csv — Jaromanda X
– Jaromanda X, Commented Jan 11, 2017 at 0:05

MoustafaS · Accepted Answer · 2017-01-11 00:08:37Z

1

Just like that:

var lines = loadedString.split('\n'); //split on newlines
    for (var i = 0; i < lines.length; i++)
    {
        var values = lines[i].split(',');
        var id = values[0];
        var start = values[1];;
        var end = values[2];;
    }

answered Jan 11, 2017 at 0:08

MoustafaS

2,03113 silver badges20 bronze badges

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

1 Comment

MG2016 Over a year ago

Thanks. I will try your suggestion for thing tomorrow.

Collectives™ on Stack Overflow

JavaScript - get csv column values

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related