Split and Join element in array Javascript

Question

I have a process mapping and splitting like this:

    var input = [{Sensor:"DHT11", Date:"28/05/2021", Time:"11:00:00", Data:"Humidity: 60.1, Temperature: 30.2"},
    {Sensor:"Piezo", Date:"28/05/2021", Time:"11:00:10", Data:"Vibration level: 10"},
    {Sensor:"PEM-004T", Date:"28/05/2021", Time:"11:00:20", Data:"Voltage: 220.3, Current: 0.13"},
    {Sensor:"DHT11", Date:"28/05/2021", Time:"11:01:00", Data:"Humidity: 60.2, Temperature: 30.0"},
    {Sensor:"Piezo", Date:"28/05/2021", Time:"11:01:10", Data:"Vibration level: 20"},
    {Sensor:"PEM-004T", Date:"28/05/2021", Time:"11:01:20", Data:"Voltage: 220.5, Current: 0.16"}
    ]
    
    const convert = (input) =>
    Object.entries(
      input
        .flatMap(({ Data, Time }) =>
          Data.split(", ").map((x, i) => ({
            data: x,
            time: Time,
          }))
        )
    )
    
    console.log(convert(input))

And now I want to split the Data key's values on the comma separator producing a new entry which on itself will be split on a new key/value pair, while keeping the timestamp association for each resulting entry:

[
  [ '0', { name: 'Humidity', data: 60.1', time: '11:00:00' } ],
  [ '1', { name: 'Temperature', data: 30.2', time: '11:00:00' } ],
  [ '2', { name: 'Vibration level', data: 10', time: '11:00:10' } ],
  [ '3', { name: 'Voltage', data: 220.3', time: '11:00:20' } ],
  [ '4', { name: 'Current', data: 0.13', time: '11:00:20' } ],
  [ '5', { name: 'Humidity', data: 60.2', time: '11:01:00' } ],
  [ '6', { name: 'Temperature', data: 30.0', time: '11:01:00' } ],
  [ '7', { name: 'Vibration level', data: 20', time: '11:01:10' } ],
  [ '8', { name: 'Voltage', data: 220.5', time: '11:01:20' } ],
  [ '9', { name: 'Current', data: 0.16', time: '11:01:20' } ]
]

How could I achieve this functionally?

And the problem is? All you need to know is already in your question. — Andreas
– Andreas, Commented May 28, 2021 at 7:34
If you don't use a short arrow function, you can easily add statements before constructing the new object: x => { /* ... commands here ... */ return { name: ..., ... }; } — user5734311
– user5734311, Commented May 28, 2021 at 7:35
I want to split the first result to the final result as I posted — CS No.1
– CS No.1, Commented May 28, 2021 at 7:39

malarres · Accepted Answer · 2021-05-28 07:38:47Z

you need to split your 'x' data into the desired values

var input = [{Sensor:"DHT11", Date:"28/05/2021", Time:"11:00:00", Data:"Humidity: 60.1, Temperature: 30.2"},
    {Sensor:"Piezo", Date:"28/05/2021", Time:"11:00:10", Data:"Vibration level: 10"},
    {Sensor:"PEM-004T", Date:"28/05/2021", Time:"11:00:20", Data:"Voltage: 220.3, Current: 0.13"},
    {Sensor:"DHT11", Date:"28/05/2021", Time:"11:01:00", Data:"Humidity: 60.2, Temperature: 30.0"},
    {Sensor:"Piezo", Date:"28/05/2021", Time:"11:01:10", Data:"Vibration level: 20"},
    {Sensor:"PEM-004T", Date:"28/05/2021", Time:"11:01:20", Data:"Voltage: 220.5, Current: 0.16"}
    ]
    
const convert = (input) =>
  Object.entries(
    input.flatMap(({ Data, Time }) =>
      Data.split(", ").map((x, i) => {
          const [nameval,dataval] = x.split(':');
        return {
          name: nameval,
          data:dataval,
          time: Time,
        };
      })
    )
  );
    
    console.log(convert(input))

Kinglish · Accepted Answer · 2021-05-28 07:39:45Z

You were basically there. Just a little adjustment in the last map() and a Number conversion on the data

var input = [{
    Sensor: "DHT11",
    Date: "28/05/2021",
    Time: "11:00:00",
    Data: "Humidity: 60.1, Temperature: 30.2"
  },
  {
    Sensor: "Piezo",
    Date: "28/05/2021",
    Time: "11:00:10",
    Data: "Vibration level: 10"
  },
  {
    Sensor: "PEM-004T",
    Date: "28/05/2021",
    Time: "11:00:20",
    Data: "Voltage: 220.3, Current: 0.13"
  },
  {
    Sensor: "DHT11",
    Date: "28/05/2021",
    Time: "11:01:00",
    Data: "Humidity: 60.2, Temperature: 30.0"
  },
  {
    Sensor: "Piezo",
    Date: "28/05/2021",
    Time: "11:01:10",
    Data: "Vibration level: 20"
  },
  {
    Sensor: "PEM-004T",
    Date: "28/05/2021",
    Time: "11:01:20",
    Data: "Voltage: 220.5, Current: 0.16"
  }
]

const convert = (input) =>
  Object.entries(
    input
    .flatMap(({
        Data,
        Time
      }) =>
      Data.split(", ").map((x, i) => {
        x = x.split(":");

        return {
          name: x[0],
          data: Number(x[1]),
          time: Time,
        }
      })
    )
  )

console.log(convert(input))

Collectives™ on Stack Overflow

Split and Join element in array Javascript

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