Json Array Delete & Change

General
1

Hi All,
I am reading data from a BMS System of a site via web services. The response received from the system is in xml which i am converting to json using xml node. The converted json contains an array of 612 objects which are the parameters I am reading.
I am trying to delete the unwanted information from the array using change node ( I tried with function node as well), but i can only delete the data that is pointing to the exact path.. i.e
This is how it looks like.

Nodered-Data
Nodered-Data1043×532 48.2 KB

I want to delete the "name" from all the 612 objects, I am not able to find out a way to generalize it. Similar problem I am facing with the change as well as in the function node where i am trying to filter the data. I want to replace the "$2d" in the "val" with "_" but i can only do it if I am pointing to exact path.

I am new and still learning, will appreciate your help ..

2

can you copy that data
image

and past into a reply

```
paste data between 3 backticks like this
```

I will provide a demo for you

3

Hi, also $ is a special character and would need to be escaped \$2d

edit/ never mind thats only in regex.

4

Hi Steve..
its " payload.obj " for the top 'obj' and "payload.obj.obj" for the next 'obj'..

5

It doesnt really matter. just copy the top most item so that it encompasses all data. I cant provide you a solution without it.

6 
{"obj":[{"str":[{"Point":{"name":"name","val":"PCHWP9$2dRUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"PCHWP9$2dAUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"PCHWP8$2dRUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"PCHWP8$2dAUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"PCHWP7$2dRUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"PCHWP7$2dAUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"PCHWP6$2dRUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"PCHWP6$2dAUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"PCHWP5$2dRUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"PCHWP5$2dAUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"PCHWP4$2dRUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"PCHWP4$2dAUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"PCHWP3$2dRUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"PCHWP3$2dAUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"PCHWP2$2dRUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"PCHWP2$2dAUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"PCHWP10$2dRUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"PCHWP10$2dAUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"PCHWP1$2dRUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"PCHWP1$2dAUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"SCHWP6$2dVFD$20RUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"SCHWP6$2dAUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"SCHWP5$2dAUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"SCHWP5$2d$20VFD$20RUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"SCHWP4$2dVFD$20RUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"SCHWP4$2dAUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"SCHWP3$2dAUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"SCHWP3$2dVFD$20RUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"SCHWP2$2dVFD$20RUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"SCHWP2$2dAUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"SCHWP1$2dVFD$20RUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"SCHWP1$2dAUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"CH$20N1$20AUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"CH$20N1$20RUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"CH$20N2$20AUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"CH$20N2$20RUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"CH$20N3$20AUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"CH$20N3$20RUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"CH$20N4$20AUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"CH$20N4$20RUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"CH$20N5$20AUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"CH$20N5$20RUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"CH$20N6$20AUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"CH$20N6$20RUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"CH$20N7$20AUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"CH$20N7$20RUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"CH_1_AUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"CH_1_RUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"CH_2_AUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"CH_2_RUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"CH_3_AUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"CH_3_RUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"CH_4_AUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"CH_4_RUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP1$2dDPS$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP3$2dDPS$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP4$2dDPS$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP2$2dDPS$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP10$2dDPS$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP5$2dDPS$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP6$2dDPS$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP7$2dDPS$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP8$2dDPS$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP9$2dDPS$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP1$2dTRIP"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP2$2dTRIP"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP3$2dTRIP"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP4$2dTRIP"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP5$2dTRIP"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP6$2dTRIP"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP7$2dTRIP"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP8$2dTRIP"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP9$2dTRIP"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP10$2dTRIP"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP1$2dSTNR$20ALARM"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP2$2dSTNR$20ALARM"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP3$2dSTNR$20ALARM"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP4$2dSTNR$20ALARM"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP5$2dSTNR$20ALARM"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP6$2dSTNR$20ALARM"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP7$2dSTNR$20ALARM"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP8$2dSTNR$20ALARM"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP9$2dSTNR$20ALARM"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP10$2dSTNR$20ALARM"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH3$20BFV$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH4$20BFV$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH1$2dFAULT$20STS$202"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH2$2dFAULT$20STS$202"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH3$2dFAULT$20STS$202"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH4$2dFAULT$20STS$202"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH1$2dFAULT$20STS$202"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH2$2dFAULT$20STS$202"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH3$2dFAULT$20STS$202"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH4$2dFAULT$20STS$202"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH1$2dFAULT$20STS$201"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH2$2dFAULT$20STS$201"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH4$2dFAULT$20STS$201"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH6$2dFAULT$20STS$201"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH3$2dFAULT$20STS$201"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH3$2dFAULT$20STS$201"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH1$2dFAULT$20STS$201"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH2$2dFAULT$20STS$201"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH5$2dFAULT$20STS$201"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH5$2dFAULT$20STS$202"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH6$2dFAULT$20STS$202"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH4$2dFAULT$20STS$201"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH2$20BFV$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH4$20BFV$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH6$20BFV$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH1$20BFV$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH2$20BFV$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH5$20BFV$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH3$20BFV$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH1$20BFV$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eDDC$2dSCHWP$2eSCHWP1$20VFD$20TRIP$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eDDC$2dSCHWP$2eSCHWP2$20VFD$20TRIP$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eDDC$2dSCHWP$2eSCHWP3$20VFD$20TRIP$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eDDC$2dSCHWP$2eSCHWP4$20VFD$20TRIP$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eDDC$2dSCHWP$2eSCHWP1$2dDPS$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eDDC$2dSCHWP$2eSCHWP2$2dDPS$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eDDC$2dSCHWP$2eSCHWP3$2dDPS$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eDDC$2dSCHWP$2eSCHWP4$2dDPS$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eDDC$2dSCHWP$2eSCHWP5$2dDPS$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eDDC$2dSCHWP$2eSCHWP6$2dDPS$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eDDC$2dSCHWP$2eSCHWP1$2dSTNR$20ALM"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eDDC$2dSCHWP$2eSCHWP2$2dSTNR$20ALM"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eDDC$2dSCHWP$2eSCHWP3$2dSTNR$20ALM"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eDDC$2dSCHWP$2eSCHWP4$2dSTNR$20ALM"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eDDC$2dSCHWP$2eSCHWP5$2dSTNR$20ALM"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eDDC$2dSCHWP$2eSCHWP6$2dSTNR$20ALM"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eDDC$2dSCHWP$2eSCHWP5$20VFD$20TRIP$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eDDC$2dSCHWP$2eSCHWP6$20VFD$20TRIP$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eSCHWP1$20VFD$2eBI$2d2"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eSCHWP1$20VFD$2eBI$2d3"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eSCHWP1$20VFD$2eBI$2d4"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eSCHWP1$20VFD$2eBI$2d5"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH7$20BFV$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH7$2dFAULT$20STS$201"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH7$2dFAULT$20STS$202"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP8$2dSS$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP9$2dSS$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP10$2dSS$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP1$2dSS$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP2$2dSS$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP3$2dSS$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP4$2dSS$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP5$2dSS$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP6$2dSS$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2ePCHWP$2ePCHWP7$2dSS$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH1$2dSS$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH4$2dSS$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH5$2dSS$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH6$2dSS$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH2$2dSS$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH3$2dSS$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH1$2dSS$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH2$2dSS$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH3$2dSS$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH4$2dSS$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH3$20BFV$20OPN$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH4$20BFV$20OPN$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH6$20BFV$20OPN$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH1$20BFV$20OPN$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH3$20BFV$20OPN$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH5$20BFV$20OPN$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH2$20BFV$20OPN$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH2$20BFV$20OPN$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH1$20BFV$20OPN$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH4$20BFV$20OPN$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eDDC$2dSCHWP$2eSCHWP5$2dS$20S$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eDDC$2dSCHWP$2eSCHWP6$2dS$20S$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eDDC$2dSCHWP$2eSCHWP1$2dS$20S$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eDDC$2dSCHWP$2eSCHWP2$2dS$20S$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eDDC$2dSCHWP$2eSCHWP3$2dS$20S$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eDDC$2dSCHWP$2eSCHWP4$2dS$20S$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eSCHWP1$20VFD$2eBO$2d4"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eSCHWP1$20VFD$2eBO$2d5"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH7$20BFV$20OPN$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"NCE1$2dCMS$2eFCB$2eLocal$20Application$2eN$2dCH7$2dSS$20CMD"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"CH_9_RUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"CH_10_RUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"CH_11_RUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"CH_8_RUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"CH_12_RUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"CH_7_RUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"CH_8_AUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"CH_10_AUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"CH_12_AUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"CH_7_AUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"CH_6_AUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"CH_5_AUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"CH_9_AUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"CH_11_AUTO$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"CH_6_RUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"CH_5_RUN$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"NCE2$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH10$2dFAULT$20STS$202"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"NCE2$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH11$2dFAULT$20STS$202"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE2$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH12$2dFAULT$20STS$202"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE2$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH10$2dFAULT$20STS$201"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE2$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH12$2dFAULT$20STS$201"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE2$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH11$2dFAULT$20STS$201"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE2$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH12$20BFV$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE2$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH11$20BFV$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE2$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH7$20BFV$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"NCE2$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH8$20BFV$20STS"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE2$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH9$2dFAULT$20STS$202"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE2$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH5$2dFAULT$20STS$202"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE2$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH6$2dFAULT$20STS$202"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE2$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH7$2dFAULT$20STS$202"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE2$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH8$2dFAULT$20STS$202"}}],"bool":[{"Point":{"name":"out.value","val":"true"}}]},{"str":[{"Point":{"name":"name","val":"NCE2$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH9$2dFAULT$20STS$201"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE2$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH7$2dFAULT$20STS$201"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]},{"str":[{"Point":{"name":"name","val":"NCE2$2dCMS$2eFCB$2eLocal$20Application$2eE$2dCH5$2dFAULT$20STS$201"}}],"bool":[{"Point":{"name":"out.value","val":"false"}}]}
7

The actual name if the tag is without $2d, I am trying to change the name to its original name..

8

I have done a demo with 3 outputs.

image

V1 - what you asked for.
V2 - slightly more sensible apporach
V3 - Probably more useful (as you can look up any value without having to search an array)

V1...
image

V2...
image

V3...
image

Demo flow...
bms-data-demo-flows.json (76.7 KB)

You should be able to make something from one of those.

9

Thanks Alot Steve.. the V3 is the perfect one.. Thanks Alot.. :slight_smile:

10

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