# Help required for data format conversion

**URL:** <https://discourse.nodered.org/t/help-required-for-data-format-conversion/22744>\
**Category:** General\
**Created:** [7 March 2020 03:47 UTC](https://discourse.nodered.org/t/help-required-for-data-format-conversion/22744 "2020-03-07T03:47:50Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ashish\_8284](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ashish_8284/32/3908_2.png) [@ashish\_8284](https://discourse.nodered.org/u/ashish_8284)\
**Post date:** [7 March 2020 03:47 UTC](https://discourse.nodered.org/t/help-required-for-data-format-conversion/22744/1 "2020-03-07T03:47:50Z")

</div>

Hi friends,  
I need help for data format conversion in node red.  
i have read three data point from PLC using Siemens S7comm node.  
data recieved is in array.  
i have converted it in to json using json node.  
v have convert below given format.  
["58.00","0.0","0.00"]

i want to convert this format in to below mentioned format  
{"Level":"58.00","Pressure":"0.0","Flow":"0.00"}

---

<div class="post-metadata">

**Author:** ![unixneo](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/unixneo/32/17441_2.png) [@unixneo](https://discourse.nodered.org/u/unixneo)\
**Post date:** [7 March 2020 04:41 UTC](https://discourse.nodered.org/t/help-required-for-data-format-conversion/22744/2 "2020-03-07T04:41:13Z")

</div>

Many ways to do this, here is a quick step-by-step little flow, perhaps you can get some ideas from this example?

 ![Screen Shot 2020-03-07 at 11.39.14 AM](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/5/c5b00b7723312c3ab92783d6168793d73d9a4d40.jpeg)

```auto
[{"id":"724e6c52.22c504","type":"inject","z":"e3827ab.e3e0688","name":"","topic":"","payload":"[\"58.00\",\"0.0\",\"0.00\"]","payloadType":"str","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":240,"y":480,"wires":[["97ddafb8.d5c1f"]]},{"id":"2f00f571.446faa","type":"function","z":"e3827ab.e3e0688","name":"","func":"var out = '{\"Level\":\"'+msg.payload[0]+'\",\"Pressure\":\"'+msg.payload[1]+'\",\"Flow\":\"'+msg.payload[2]+'\"}';\nvar newMsg = {payload:out};\nreturn newMsg;\n","outputs":1,"noerr":0,"x":570,"y":480,"wires":[["a3cd5a1.04ccea8"]]},{"id":"ff1f9002.54cc6","type":"debug","z":"e3827ab.e3e0688","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":900,"y":480,"wires":[]},{"id":"a3cd5a1.04ccea8","type":"json","z":"e3827ab.e3e0688","name":"","property":"payload","action":"","pretty":false,"x":730,"y":480,"wires":[["ff1f9002.54cc6"]]},{"id":"97ddafb8.d5c1f","type":"json","z":"e3827ab.e3e0688","name":"","property":"payload","action":"obj","pretty":false,"x":430,"y":480,"wires":[["2f00f571.446faa"]]}]

```

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [7 March 2020 14:49 UTC](https://discourse.nodered.org/t/help-required-for-data-format-conversion/22744/3 "2020-03-07T14:49:54Z")

</div>

Easily done with a change node and JSONata or with a function node.

Example (untested) JSONata:

```auto
{
    "Level": payload[0],
    "Pressure": payload[1],
    "Flow": payload[2]
}

```

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [6 May 2020 14:50 UTC](https://discourse.nodered.org/t/help-required-for-data-format-conversion/22744/4 "2020-05-06T14:50:00Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.