# Split the string and set to number

**URL:** https://discourse.nodered.org/t/split-the-string-and-set-to-number/36727
**Category:** General
**Created:** [29 November 2020 19:04 UTC](https://discourse.nodered.org/t/split-the-string-and-set-to-number/36727 "2020-11-29T19:04:08Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Napster](https://avatars.discourse-cdn.com/v4/letter/n/65b543/32.png) [@Napster](https://discourse.nodered.org/u/Napster)
#### Post date: [29 November 2020 19:04 UTC](https://discourse.nodered.org/t/split-the-string-and-set-to-number/36727/1 "2020-11-29T19:04:08Z")

</div>

Hello,

0-1:24.2.3(201129181002W)(00050.845\*m3)

I got this payload from my smart meter, i need only the m3 value.

How can i do that ?

Kind Regards

---

<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: [29 November 2020 19:59 UTC](https://discourse.nodered.org/t/split-the-string-and-set-to-number/36727/2 "2020-11-29T19:59:26Z")

</div>

There are a few ways, heres one using the change node and regex.

```auto
[{"id":"e0597e54.0f3c18","type":"inject","z":"8d22ae29.7df6d","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"0-1:24.2.3(201129181002W)(00050.845*m3)","payloadType":"str","x":120,"y":2880,"wires":[["5cc60b28.f825bc"]]},{"id":"5cc60b28.f825bc","type":"change","z":"8d22ae29.7df6d","name":"","rules":[{"t":"change","p":"payload","pt":"msg","from":".*\\)\\((.*)\\*m3\\)","fromt":"re","to":"$1","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":360,"y":2880,"wires":[["39c1c718.e9731"]]},{"id":"39c1c718.e9731","type":"debug","z":"8d22ae29.7df6d","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":590,"y":2860,"wires":[]}]

```

Fixed missing change node.

---

<div class="post-metadata">

### Author: ![bakman2](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bakman2/32/6207_2.png) [@bakman2](https://discourse.nodered.org/u/bakman2)
#### Post date: [29 November 2020 19:59 UTC](https://discourse.nodered.org/t/split-the-string-and-set-to-number/36727/3 "2020-11-29T19:59:39Z")

</div>

This is not a robust solution, but regular expressions can extract this more "easily" (this will match `5 digits` `.` `3 digits`)

 ![Screenshot 2020-11-29 at 20.57.50](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/5/9/596366b0a4adef9ebe07ed6b1c4e46208e049502.jpeg)

@E1cid at the same time 😉 you are missing the change node in your flow

---

<div class="post-metadata">

### Author: ![Napster](https://avatars.discourse-cdn.com/v4/letter/n/65b543/32.png) [@Napster](https://discourse.nodered.org/u/Napster)
#### Post date: [29 November 2020 20:08 UTC](https://discourse.nodered.org/t/split-the-string-and-set-to-number/36727/4 "2020-11-29T20:08:39Z")

</div>

Thanks a lot !! 🙂
