# How to delete certain part of Message of sensor data?

**URL:** https://discourse.nodered.org/t/how-to-delete-certain-part-of-message-of-sensor-data/61221
**Category:** General
**Tags:** function-node, database, mqtt
**Created:** [13 April 2022 07:42 UTC](https://discourse.nodered.org/t/how-to-delete-certain-part-of-message-of-sensor-data/61221 "2022-04-13T07:42:09Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![SammyJang](https://avatars.discourse-cdn.com/v4/letter/s/e56c9b/32.png) [@SammyJang](https://discourse.nodered.org/u/SammyJang)
#### Post date: [13 April 2022 07:42 UTC](https://discourse.nodered.org/t/how-to-delete-certain-part-of-message-of-sensor-data/61221/1 "2022-04-13T07:42:09Z")

</div>

Hi, I'm now working on a project to send data to my AWS DB.  
I have Wireless Sensor node which is connected to function, debug and mqtt out node.  
The sensor data is comming to debug page like this,  
{  
"addr": {  
"S": "00:13:a2:00:41:f0:48:63"  
},  
"received": {  
"S": "1649102906154"  
},  
"payload": {  
"M": {  
"rms\_x": {  
"N": "749.56"  
},  
"rms\_z": {  
"N": "119.63"  
},  
"rms\_y": {  
"N": "1391.97"  
},  
"max\_x": {  
"N": "0"  
},  
"max\_z": {  
"N": "244.83"  
},  
"max\_y": {  
"N": "0"  
},  
"reserve": {  
"N": "1"  
},  
"data\_type": {  
"S": "Acceleration"  
},  
"temperature": {  
"N": "25"  
},  
"min\_x": {  
"N": "-821.09"  
},  
"min\_z": {  
"N": "0"  
},  
"min\_y": {  
"N": "-1537.81"  
},  
"status": {  
"S": "Valid"  
}  
}  
}  
}  
But if I could delete certain points(I marked on the picture), then the data will be stored very nicely to the DB system. But I'm not sure that I could delete that part by using the function of Node-Red. Please let me know if you have any idea of it. I don't really know about the programming since I'm just an engineering student. Please help me, Thank you !

 ![Screenshot 2022-04-13 023658](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/a/8/a81e549760dea8ba428c898a571a242faa3a9727.png)

- I want to delete those marked parts.

---

<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: [13 April 2022 08:04 UTC](https://discourse.nodered.org/t/how-to-delete-certain-part-of-message-of-sensor-data/61221/2 "2022-04-13T08:04:15Z")

</div>

Welcome to the forum Sammy. You may wish to do one of the excellent short courses or watch some videos on the use of Node-RED in order to familiarise yourself with its basic use.

You can use a change node to remove some aspects of a message before passing it onwards.

---

<div class="post-metadata">

### Author: ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [13 April 2022 08:41 UTC](https://discourse.nodered.org/t/how-to-delete-certain-part-of-message-of-sensor-data/61221/3 "2022-04-13T08:41:49Z")

</div>

Hi.

As Julian says, you should watch some of the short videos - your question is a very basic one.

I will post some links below after the demo GIF I did...  
 ![chrome_cakR3lacv4](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/0/8/085693cbaccb14b7d55c750eaa6ceee5b9c1b21f.gif)

* * *

### canned text...

#### get path to to data item

There’s a great page in the docs ([Working with messages : Node-RED](https://nodered.org/docs/user-guide/messages)) that will explain how to use the debug panel to find the right path to any data item.

Pay particular attention to the part about the buttons that appear under your mouse pointer when you over hover a debug message property in the sidebar.

![BX00Cy7yHi](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/d/bd1f333a9e043b061b39917c328b0094d3e52d30.gif)

#### recommended watching

I recommend watching this playlist: [Node-RED Essentials](https://www.youtube.com/playlist?list=PLyNBB9VCLmo1hyO-4fIZ08gqFcXBkHy-6). The videos are done by the developers of node-red. They're nice & short and to the point. You will understand a whole lot more in about 1 hour. A small investment for a lot of gain.

---

<div class="post-metadata">

### Author: ![SammyJang](https://avatars.discourse-cdn.com/v4/letter/s/e56c9b/32.png) [@SammyJang](https://discourse.nodered.org/u/SammyJang)
#### Post date: [13 April 2022 14:37 UTC](https://discourse.nodered.org/t/how-to-delete-certain-part-of-message-of-sensor-data/61221/4 "2022-04-13T14:37:09Z")

</div>

Thank you so much for letting me know how I will study for that development. Imma watch that video right now thank you!

---

<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: [12 June 2022 14:37 UTC](https://discourse.nodered.org/t/how-to-delete-certain-part-of-message-of-sensor-data/61221/5 "2022-06-12T14:37:43Z")

</div>

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