Convert array object to value of strings

Question

I have an array of objects structured like this:

[{ a: '1', b : '2'}, {a : '3', b : '4'}]

For the purpose of preparing data for insertion into database, I need a string of object values like this:

('1', '2'),('3', '4')

With the same ordering of values.. apart from the naive way of iterating through each object in array and constructing a string, is there a better much easier way of doing this?

If your string values are more than just simple digits, you'd want to rely on query formatting methods that are available within the database framework that you are using. Otherwise, you are risking to create invalid strings when they have special symbols in them. — vitaly-t
– vitaly-t, Commented Dec 5, 2015 at 9:51

Nikhil Aggarwal · Accepted Answer · 2015-12-04 15:56:11Z

6

Try following

var arr = [{ a: '1', b : '2'}, {a : '3', b : '4'}];
    
var result = arr.map(function(item){
    return "('" + item.a + "', '" +  item.b + "')";    
});
    
console.log(result);
console.log(result.join());

answered Dec 4, 2015 at 15:56

Nikhil Aggarwal

28.5k4 gold badges46 silver badges61 bronze badges

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

Comments

VahagnNikoghosian · Accepted Answer · 2015-12-04 16:03:16Z

2

For on line lovers.

var arr = [{ a: '1', b : '2'}, {a : '3', b : '4'}];

var result = arr.reduce(function(result, item, i){
    return result + "('" + item.a + "', '" +  item.b + "')" + i===arr.length-1?'': ',';    
}, '');

answered Dec 4, 2015 at 16:03

VahagnNikoghosian

6136 silver badges18 bronze badges

Collectives™ on Stack Overflow

Convert array object to value of strings

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related