Retrieve only the column of a javascript array

Question

After doing an Sql query, I have an array that looks like the one below. I would like to retrieve only the "name" column in a way that the names are like this: "Name1, Name2, Name3". I have no idea how to do this, I looked on the internet but I find nothing conclusive. Do you have any idea how to retrieve all the data from the "name" column? Thank you in advance.

Array =
[1] {
    id_idx: 1,
    hero_order: 0,
    name: 'Nom1'
},
[2] {
    id_idx: 1,
    hero_order: 0,
    name: 'Nom2'
},
[3]  {
    id_idx: 1,
    hero_order: 0,
    name: 'Nom3'
}

I forgot one information: the array comes from an SQL query rows2[].name.

let result=array.map(data=>data.name)

Aditya Menon
– Aditya Menon

2020-11-27 10:42:32 +00:00
Commented Nov 27, 2020 at 10:42 — Aditya Menon
– Aditya Menon, Commented Nov 27, 2020 at 10:42

Nift · Accepted Answer · 2020-11-27 10:46:39Z

1

You can utilize the map function on any JavaScript array, docs: https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Map

Basically a map function tranforms type "A" to type "B". In your case you want to go from the type:

Array<{
    id_idx: number,
    hero_order: number,
    name: string
}>

To:

Array<string>

This can be done with the map function as follows:

const names = myArray.map(a => a.name);

answered Nov 27, 2020 at 10:46

Nift

3604 silver badges10 bronze badges

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

Comments

Durgesh · Accepted Answer · 2020-11-27 10:55:29Z

0

Following code should give you a working solution -

const result = [{
    id_idx: 1,
    hero_order: 0,
    name: 'Nom1'
},
{
    id_idx: 1,
    hero_order: 0,
    name: 'Nom2'
},
{
    id_idx: 1,
    hero_order: 0,
    name: 'Nom3'
}]

const outputArray = result.map((singleResult) => singleResult.name);

const outputString = outputArray.join(",");

console.log("This will give you an array as output - " + outputArray);

console.log("This will give you string as a output - " + outputString);

console.log('outputArray type:' + typeof outputArray);

console.log('outputString type:' + typeof outputString);

answered Nov 27, 2020 at 10:55

Durgesh

1952 silver badges12 bronze badges

Collectives™ on Stack Overflow

Retrieve only the column of a javascript array

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