# Convert array to a specified string for a telnet connection

**URL:** <https://discourse.nodered.org/t/convert-array-to-a-specified-string-for-a-telnet-connection/60701>\
**Category:** General\
**Tags:** function-node\
**Created:** [2 April 2022 21:49 UTC](https://discourse.nodered.org/t/convert-array-to-a-specified-string-for-a-telnet-connection/60701 "2022-04-02T21:49:58Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![tim26](https://avatars.discourse-cdn.com/v4/letter/t/e0b2c6/32.png) [@tim26](https://discourse.nodered.org/u/tim26)\
**Post date:** [2 April 2022 21:49 UTC](https://discourse.nodered.org/t/convert-array-to-a-specified-string-for-a-telnet-connection/60701/1 "2022-04-02T21:49:58Z")

</div>

Hey,  
i please need help with a function node.  
From a sql query i get an array with a variable number of objects.  
Example:

 ![array](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/8/484dc49b48a454369a4dfd0c69de93d813100619.jpeg)

Now i need to send this data via a telnet connection to my device as follows:

1010000021325-020|1090000021219-025C|.....

Can please anybody help me with the function node to realize this?

Thanks in advance

Tim

---

<div class="post-metadata">

**Author:** ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)\
**Post date:** [2 April 2022 22:10 UTC](https://discourse.nodered.org/t/convert-array-to-a-specified-string-for-a-telnet-connection/60701/2 "2022-04-02T22:10:54Z")

</div>

Try

```auto
msg.payload = msg.payload.map(v => Object.values(v).join("")).join("|");
return msg;

```

---

<div class="post-metadata">

**Author:** ![HaroldPetersInskipp](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/haroldpetersinskipp/32/42319_2.png) [@HaroldPetersInskipp](https://discourse.nodered.org/u/HaroldPetersInskipp)\
**Post date:** [2 April 2022 22:22 UTC](https://discourse.nodered.org/t/convert-array-to-a-specified-string-for-a-telnet-connection/60701/3 "2022-04-02T22:22:54Z")

</div>

Something like this might get you close:

```auto
msg.payload = Object.entries(msg.payload);
let result = "";
for (let i = 0; i < msg.payload.length; i++) {
    result += msg.payload[i][1];
};
msg.payload = result;
return msg;

```

---

<div class="post-metadata">

**Author:** ![tim26](https://avatars.discourse-cdn.com/v4/letter/t/e0b2c6/32.png) [@tim26](https://discourse.nodered.org/u/tim26)\
**Post date:** [3 April 2022 10:21 UTC](https://discourse.nodered.org/t/convert-array-to-a-specified-string-for-a-telnet-connection/60701/4 "2022-04-03T10:21:59Z")

</div>

Thank to both of you!  
This works well for me.  
Thank you for your help!

---

<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:** [2 June 2022 10:22 UTC](https://discourse.nodered.org/t/convert-array-to-a-specified-string-for-a-telnet-connection/60701/5 "2022-06-02T10:22:51Z")

</div>

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