# Getting specific data from a large xml

**URL:** <https://discourse.nodered.org/t/getting-specific-data-from-a-large-xml/39191>\
**Category:** General\
**Created:** [15 January 2021 17:37 UTC](https://discourse.nodered.org/t/getting-specific-data-from-a-large-xml/39191 "2021-01-15T17:37:25Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![luks](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/luks/32/33365_2.png) [@luks](https://discourse.nodered.org/u/luks)\
**Post date:** [15 January 2021 17:37 UTC](https://discourse.nodered.org/t/getting-specific-data-from-a-large-xml/39191/1 "2021-01-15T17:37:25Z")

</div>

Hi everyone,

So, i'm working with a machine that posts its setup information in a .xml file, but it's information comes in a History topic. So if someone changes any setup value the "actual value" will be written furter in the history (See image below).

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/2/4/24138357ac86ce6b45d45b4209091c22bd520a13.png)

I need to get only the last value of each setup variable, like if "Zones Set value bottom [°C] Zone 10 from 240 to 215" was the last modification of "ZONE 10", 215 is what i need.

I managed to get and transform the xml file into jason like this:  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/2/6/26120ca61713e1bb0c92456858e5759aaa71a774.png)

and the result was:

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/d/b/db7887a118530f4f836f210ad5a904eb7e433d29.png)

but because of lacking javascript skills i'm stuck and need u guys!

any help will be appreciated!!

---

<div class="post-metadata">

**Author:** ![UnborN](https://avatars.discourse-cdn.com/v4/letter/u/4491bb/32.png) [@UnborN](https://discourse.nodered.org/u/UnborN)\
**Post date:** [15 January 2021 18:12 UTC](https://discourse.nodered.org/t/getting-specific-data-from-a-large-xml/39191/2 "2021-01-15T18:12:56Z")

</div>

You can use something called Regular Expressions in a Function node to filter out the numbers and pick the last one which is the number you want.

```auto
//regex match digits (numbers) and take the last [2]
let number = Number(msg.payload.match(/\d+/g)[2])

// filter out the zone with regex
let zone = msg.payload.match(/Zone\s(\S)+/g)[0]

msg.payload = {}
msg.payload.zone = zone
msg.payload.number = number

return msg;

```

**Example:**

```auto
[{"id":"fa0639af.697938","type":"inject","z":"ac0f61dd.69e26","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"Zones Set value bottom [°C] Zone 10 from 240 to 215","payloadType":"str","x":240,"y":840,"wires":[["a37dbc9f.4775e8"]]},{"id":"a37dbc9f.4775e8","type":"function","z":"ac0f61dd.69e26","name":"Regex match","func":"//regex match digits (numbers) and take the last [2]\nlet number = Number(msg.payload.match(/\\d+/g)[2])\n\n// filter out the zone wit regex\nlet zone = msg.payload.match(/Zone\\s(\\S)+/g)[0]\n\nmsg.payload = {}\nmsg.payload.zone = zone\nmsg.payload.number = number\n\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":420,"y":840,"wires":[["fcfd4a1b.334da8"]]},{"id":"fcfd4a1b.334da8","type":"debug","z":"ac0f61dd.69e26","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":670,"y":840,"wires":[]}]

```

If you want to apply it for all elements of the History array then use the **Copy value** icon on the root of your msg from the Debug window and send as a copy to play with 😉

---

<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:** [15 January 2021 18:19 UTC](https://discourse.nodered.org/t/getting-specific-data-from-a-large-xml/39191/3 "2021-01-15T18:19:26Z")

</div>

If you walk through the History[0] object with

```auto
const out = ()
history = msg.payload.SOLDER_PRG.History[0]
const hKeys = Object.keys(history)
Object.keys(hKeys).forEach( key => {
    let myitem = history[key][0]
    let zone = '' // you need to use probably a regex to extract the right zone from myitem - if nobody has answered after my dinner, I'll try and put something together.
    let temp = '' // another regex needed here or combine with above
    let dt = '' // same for date/time if you need that
    out[zone] = {dt: dt, temp: temp, zone: zone}
})

msg.payload = out
return msg

```

Because you use an object, as long as the History is in the right order, you will end up with the last entry being kept and everything else ignored (because it is overwritten as you go along).

---

<div class="post-metadata">

**Author:** ![luks](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/luks/32/33365_2.png) [@luks](https://discourse.nodered.org/u/luks)\
**Post date:** [18 January 2021 22:33 UTC](https://discourse.nodered.org/t/getting-specific-data-from-a-large-xml/39191/4 "2021-01-18T22:33:11Z")

</div>

I tried but it doesn't seem to work to all file. How do i specify wich zone i want? I want all zones. If i use the file as a string, it returns me the wrong value, it is returning me '10'.

```auto
<?xml version="1.0" encoding="UTF-8"?><!-- Factory solder PRG DOC --><SOLDER_PRG> <Version>1.10</Version> <PrgName> <stfProg>BASEBOARD.xml</stfProg> </PrgName> <Bib> <stfBib>TBK</stfBib> </Bib> <Info> <stfInfo>Defaultprogram</stfInfo> </Info> <Benutzer> <stfBenutzer>factory</stfBenutzer> </Benutzer> <History> <Items>65</Items> <Item_0>2017.10.09 07:48:47 User:Service Zones Set value top [°C] Zone 1 from 120 to 90</Item_0> <Item_1>2017.10.09 07:48:47 User:Service Zones Set value top [°C] Zone 2 from 150 to 110</Item_1> <Item_2>2017.10.09 07:48:47 User:Service Zones Set value top [°C] Zone 3 from 180 to 130</Item_2> <Item_3>2017.10.09 07:48:47 User:Service Zones Set value top [°C] Zone 4 from 200 to 145</Item_3> <Item_4>2017.10.09 07:48:47 User:Service Zones Set value top [°C] Zone 5 from 170 to 150</Item_4> <Item_5>2017.10.09 07:48:47 User:Service Zones Set value top [°C] Zone 6 from 170 to 165</Item_...

```

here is the copy u asked, but it came incomplete for some reason.

---

<div class="post-metadata">

**Author:** ![luks](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/luks/32/33365_2.png) [@luks](https://discourse.nodered.org/u/luks)\
**Post date:** [18 January 2021 22:41 UTC](https://discourse.nodered.org/t/getting-specific-data-from-a-large-xml/39191/5 "2021-01-18T22:41:57Z")

</div>

Hi, i tried this way:

```auto
const out = ()
history = msg.payload.SOLDER_PRG.History[0]
const hKeys = Object.keys(history)
Object.keys(hKeys).forEach( key => {
    let myitem = history[key][0]
    let zone = Number(msg.payload.match(/\d+/g)[2]) 
    let temp = msg.payload.match(/Zone 2\s(\S)+/g)[0]
    out[zone] = {temp: temp, zone: zone}
})

msg.payload = out
return msg

```

I got this:  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/6/8/6853e5534667b4550ddeed378de89709d18bb77c.png)

How will it filter wich zone i want? Regex matches the exactly string?

Tnx for replying!

---

<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:** [18 January 2021 22:44 UTC](https://discourse.nodered.org/t/getting-specific-data-from-a-large-xml/39191/6 "2021-01-18T22:44:52Z")

</div>

change line 1 to `const out = {}`

---

<div class="post-metadata">

**Author:** ![luks](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/luks/32/33365_2.png) [@luks](https://discourse.nodered.org/u/luks)\
**Post date:** [18 January 2021 22:46 UTC](https://discourse.nodered.org/t/getting-specific-data-from-a-large-xml/39191/7 "2021-01-18T22:46:22Z")

</div>

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/f/2/f2fdfa10097c5a3c53350c571e1874729c290333.png)

Tnx. Now, another one haha!

---

<div class="post-metadata">

**Author:** ![UnborN](https://avatars.discourse-cdn.com/v4/letter/u/4491bb/32.png) [@UnborN](https://discourse.nodered.org/u/UnborN)\
**Post date:** [18 January 2021 22:46 UTC](https://discourse.nodered.org/t/getting-specific-data-from-a-large-xml/39191/8 "2021-01-18T22:46:49Z")

</div>

> [@luks](#):
>
> here is the copy u asked, but it came incomplete for some reason.

is it possible to try to send the complete xml data .. because you will need some filtering of the lines that dont include a Zone like you show in your first screenshot

---

<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:** [18 January 2021 22:46 UTC](https://discourse.nodered.org/t/getting-specific-data-from-a-large-xml/39191/9 "2021-01-18T22:46:52Z")

</div>

can you attach a full valid XML file?

---

<div class="post-metadata">

**Author:** ![luks](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/luks/32/33365_2.png) [@luks](https://discourse.nodered.org/u/luks)\
**Post date:** [18 January 2021 22:50 UTC](https://discourse.nodered.org/t/getting-specific-data-from-a-large-xml/39191/10 "2021-01-18T22:50:04Z")

</div>

It doesnt accept .xml, so i'm sending a .txt!

[BASEBOARD.txt](https://discourse.nodered.org/uploads/short-url/SUEKzybwnMGpdQwpJcpMG1KV2x.txt) (64.1 KB)

---

<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:** [18 January 2021 23:10 UTC](https://discourse.nodered.org/t/getting-specific-data-from-a-large-xml/39191/11 "2021-01-18T23:10:15Z")

</div>

Any good?

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/8/b87c9c88c5125c652e25a856dbae483dd5f57a21.png)

Demo flow...

```auto
[{"id":"dd11d063.35bfb","type":"inject","z":"59f3e1c6.409f8","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":610,"y":540,"wires":[["80016038.2eea5"]]},{"id":"80016038.2eea5","type":"template","z":"59f3e1c6.409f8","name":"xml","field":"payload","fieldType":"msg","format":"html","syntax":"mustache","template":"<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<!-- Factory solder PRG DOC -->\n<SOLDER_PRG>\n <Version>1.10</Version>\n <PrgName>\n <stfProg>BASEBOARD.xml</stfProg>\n </PrgName>\n <Bib>\n <stfBib>TBK</stfBib>\n </Bib>\n <Info>\n <stfInfo>Defaultprogram</stfInfo>\n </Info>\n <Benutzer>\n <stfBenutzer>factory</stfBenutzer>\n </Benutzer>\n <History>\n <Items>65</Items>\n <Item_0>2017.10.09 07:48:47 User:Service Zones Set value top [°C] Zone 1 from 120 to 90</Item_0>\n <Item_1>2017.10.09 07:48:47 User:Service Zones Set value top [°C] Zone 2 from 150 to 110</Item_1>\n <Item_2>2017.10.09 07:48:47 User:Service Zones Set value top [°C] Zone 3 from 180 to 130</Item_2>\n <Item_3>2017.10.09 07:48:47 User:Service Zones Set value top [°C] Zone 4 from 200 to 145</Item_3>\n <Item_4>2017.10.09 07:48:47 User:Service Zones Set value top [°C] Zone 5 from 170 to 150</Item_4>\n <Item_5>2017.10.09 07:48:47 User:Service Zones Set value top [°C] Zone 6 from 170 to 165</Item_5>\n </History>\n</SOLDER_PRG>","output":"str","x":750,"y":540,"wires":[["b3a5e3f1.ed7b1"]]},{"id":"c0903850.b315c8","type":"function","z":"59f3e1c6.409f8","name":"","func":"const out = {}\nvar history = msg.payload.SOLDER_PRG.History[0]\nconst hKeys = Object.keys(history)\n\nfor (let index = 0; index < hKeys.length; index++) {\n const key = hKeys[index];\n const myitem = history[key];\n if(myitem && myitem.length) {\n let str = myitem[0];\n let matches = /Zone (\\d+).*?(\\d+).*?(\\d+)/g.exec(str)\n if (!matches || matches.length < 3) continue\n let _zone = matches[1]\n let _from = Number(matches[2])\n let _to = Number(matches[3])\n out[\"Zone_\" + _zone] = { zone: _zone, from: _from, to: _to } \n } \n}\n\nmsg.payload = out\nreturn msg\n","outputs":1,"noerr":0,"initialize":"","finalize":"","x":1000,"y":540,"wires":[["d14ca258.31617"]]},{"id":"d14ca258.31617","type":"debug","z":"59f3e1c6.409f8","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":1150,"y":540,"wires":[]},{"id":"b3a5e3f1.ed7b1","type":"xml","z":"59f3e1c6.409f8","name":"","property":"payload","attr":"","chr":"","x":870,"y":540,"wires":[["c0903850.b315c8","36360b58.a9c4a4"]]},{"id":"36360b58.a9c4a4","type":"debug","z":"59f3e1c6.409f8","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":990,"y":580,"wires":[]}]

```

---

<div class="post-metadata">

**Author:** ![UnborN](https://avatars.discourse-cdn.com/v4/letter/u/4491bb/32.png) [@UnborN](https://discourse.nodered.org/u/UnborN)\
**Post date:** [18 January 2021 23:30 UTC](https://discourse.nodered.org/t/getting-specific-data-from-a-large-xml/39191/12 "2021-01-18T23:30:24Z")

</div>

That was super fast Steve 😉

my contribution ..

```auto
let arr = Object.values(msg.payload.SOLDER_PRG.History[0])

let result = []

arr.forEach(el => {
    
    // test if Zone actually exists
    if ( /Zone\s(\S)+/g.test(el[0])) {
         //regex match digits (numbers) and take the last [2]
         let value = Number(el[0].match(/\d+/g)[8])
         // filter out the zone with regex
         let zone = el[0].match(/Zone\s(\S)+/g)[0]
         result.push({zone, value})
    }
   
})

msg.payload = result

return msg;

```

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/e/e/ee1a8e417e60f98772cae640720e1982cb48fb72.png)

---

<div class="post-metadata">

**Author:** ![luks](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/luks/32/33365_2.png) [@luks](https://discourse.nodered.org/u/luks)\
**Post date:** [18 January 2021 23:41 UTC](https://discourse.nodered.org/t/getting-specific-data-from-a-large-xml/39191/13 "2021-01-18T23:41:45Z")

</div>

It's working exactly how i wanted! It's taking the last updated value to each zone, no matter how much changes happen! I couldn't fully comprehend it, so one last question, how would i wrote the code if i wanted Conveyor speed and width

```auto
 <Item_10>2017.10.09 07:52:40 User:Service Conveyor conv.1 from 100 cm/min to 75 cm/min</Item_10>
<Item_18>2017.10.25 17:26:00 User:produza Width Conveyor width (Width 1) from 100 mm to 90,5 mm</Item_18>

```

U guys are f\*\*\*ng awesome!!

---

<div class="post-metadata">

**Author:** ![UnborN](https://avatars.discourse-cdn.com/v4/letter/u/4491bb/32.png) [@UnborN](https://discourse.nodered.org/u/UnborN)\
**Post date:** [19 January 2021 00:58 UTC](https://discourse.nodered.org/t/getting-specific-data-from-a-large-xml/39191/14 "2021-01-19T00:58:49Z")

</div>

good you asked that last question because personally i didnt take into consideration that your values could be a floating point value and that changes the filtering a bit

maybe this?

```auto
let arr = Object.values(msg.payload.SOLDER_PRG.History[0])

let result = {}

arr.forEach(el => {
    
    // test if Zone actually exists
    if ( /Zone\s(\S)+/g.test(el[0])) {
         //regex match digits (numbers) 
         let from = Number(el[0].match(/\d+\,?\d+?/g)[6].replace(",", "."))
         let to = Number(el[0].match(/\d+\,?\d+?/g)[7].replace(",", "."))
         // filter out the zone with regex
         let zone = el[0].match(/Zone\s(\S)+/g)[0]
         result[zone] = {zone, from, to}
    }
    // test if Service Conveyor exists
    if (/Service\s\sConveyor/g.test(el[0])) {
         let from = Number(el[0].match(/\d+\,?\d+?/g)[6].replace(",", "."))
         let to = Number(el[0].match(/\d+\,?\d+?/g)[7].replace(",", "."))
         // filter out the Conveyor with regex
         let conv = el[0].match(/conv\.\d+/g)[0]
         result[conv] = {conv, from, to}
    }
     // test if Conveyor width exists
    if (/Conveyor\swidth/g.test(el[0])) {
         let from = Number(el[0].match(/\d+\,?\d+?/g)[6].replace(",", "."))
         let to = Number(el[0].match(/\d+\,?\d+?/g)[7].replace(",", "."))
       
         result["produza"] = {from, to}
    }
 
})

msg.payload = result

return msg;

```

ps. there are multiple `User:produza Width Conveyor width` entries.  
you need only the latest one ?

---

<div class="post-metadata">

**Author:** ![luks](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/luks/32/33365_2.png) [@luks](https://discourse.nodered.org/u/luks)\
**Post date:** [19 January 2021 01:11 UTC](https://discourse.nodered.org/t/getting-specific-data-from-a-large-xml/39191/15 "2021-01-19T01:11:07Z")

</div>

Tried the code and got this:  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/e/ceeae9935d8c647f67cca5d3387dc1a0e28da2bf.png)

Yes, i need only the last update to the following variables:  
Zone 1..10, Cooling Zone 1, Conveyor Speed and Width.

---

<div class="post-metadata">

**Author:** ![UnborN](https://avatars.discourse-cdn.com/v4/letter/u/4491bb/32.png) [@UnborN](https://discourse.nodered.org/u/UnborN)\
**Post date:** [19 January 2021 01:15 UTC](https://discourse.nodered.org/t/getting-specific-data-from-a-large-xml/39191/16 "2021-01-19T01:15:22Z")

</div>

Where did you add the Function node code ?  
Right after the XML node ?

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/2/6/26dd2645a4028dbe2251e7c9934312c79effeafc.png)

---

<div class="post-metadata">

**Author:** ![luks](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/luks/32/33365_2.png) [@luks](https://discourse.nodered.org/u/luks)\
**Post date:** [19 January 2021 01:18 UTC](https://discourse.nodered.org/t/getting-specific-data-from-a-large-xml/39191/17 "2021-01-19T01:18:07Z")

</div>

Yeah, exactly like that

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/c/9c9494c7373e64c0e643f6d0b24fe7a8f2ee0e9e.png)

the one u sent before was working!

---

<div class="post-metadata">

**Author:** ![UnborN](https://avatars.discourse-cdn.com/v4/letter/u/4491bb/32.png) [@UnborN](https://discourse.nodered.org/u/UnborN)\
**Post date:** [19 January 2021 01:21 UTC](https://discourse.nodered.org/t/getting-specific-data-from-a-large-xml/39191/18 "2021-01-19T01:21:46Z")

</div>

Dunno .. its working for me .. here's the Flow

```auto
[{"id":"fa0639af.697938","type":"inject","z":"ac0f61dd.69e26","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"Zones Set value bottom [°C] Zone 10 from 240 to 215","payloadType":"str","x":150,"y":700,"wires":[["5c600d6c.fa489c"]]},{"id":"a37dbc9f.4775e8","type":"function","z":"ac0f61dd.69e26","name":"Regex match","func":"let arr = Object.values(msg.payload.SOLDER_PRG.History[0])\n\nlet result = {}\n\narr.forEach(el => {\n \n // test if Zone actually exists\n if ( /Zone\\s(\\S)+/g.test(el[0])) {\n //regex match digits (numbers) \n let from = Number(el[0].match(/\\d+\\,?\\d+?/g)[6].replace(\",\", \".\"))\n let to = Number(el[0].match(/\\d+\\,?\\d+?/g)[7].replace(\",\", \".\"))\n // filter out the zone with regex\n let zone = el[0].match(/Zone\\s(\\S)+/g)[0]\n result[zone] = {zone, from, to}\n }\n // test if Service Conveyor exists\n if (/Service\\s\\sConveyor/g.test(el[0])) {\n let from = Number(el[0].match(/\\d+\\,?\\d+?/g)[6].replace(\",\", \".\"))\n let to = Number(el[0].match(/\\d+\\,?\\d+?/g)[7].replace(\",\", \".\"))\n // filter out the Conveyor with regex\n let conv = el[0].match(/conv\\.\\d+/g)[0]\n result[conv] = {conv, from, to}\n }\n // test if Conveyor width exists\n if (/Conveyor\\swidth/g.test(el[0])) {\n let from = Number(el[0].match(/\\d+\\,?\\d+?/g)[6].replace(\",\", \".\"))\n let to = Number(el[0].match(/\\d+\\,?\\d+?/g)[7].replace(\",\", \".\"))\n \n result[\"produza\"] = {from, to}\n }\n \n})\n\n\nmsg.payload = result\n\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":670,"y":700,"wires":[["fcfd4a1b.334da8"]]},{"id":"fcfd4a1b.334da8","type":"debug","z":"ac0f61dd.69e26","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":890,"y":700,"wires":[]},{"id":"4ed03110.fe5be8","type":"xml","z":"ac0f61dd.69e26","name":"","property":"payload","attr":"","chr":"","x":450,"y":700,"wires":[["a37dbc9f.4775e8","bfeb104a.25ef58"]]},{"id":"5c600d6c.fa489c","type":"file in","z":"ac0f61dd.69e26","name":"xml","filename":"C:\\Users\\user\\desktop\\baseboard.xml","format":"utf8","chunk":false,"sendError":false,"encoding":"none","x":290,"y":700,"wires":[["4ed03110.fe5be8"]]},{"id":"bfeb104a.25ef58","type":"debug","z":"ac0f61dd.69e26","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":600,"y":640,"wires":[]}]

```

Change the File in path to your file

---

<div class="post-metadata">

**Author:** ![luks](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/luks/32/33365_2.png) [@luks](https://discourse.nodered.org/u/luks)\
**Post date:** [19 January 2021 01:36 UTC](https://discourse.nodered.org/t/getting-specific-data-from-a-large-xml/39191/19 "2021-01-19T01:36:12Z")

</div>

It works!

Thank you guys very much! I wish i could mark u both as "solution"!

U guys made me happier! U r awesomeee!

---

<div class="post-metadata">

**Author:** ![UnborN](https://avatars.discourse-cdn.com/v4/letter/u/4491bb/32.png) [@UnborN](https://discourse.nodered.org/u/UnborN)\
**Post date:** [19 January 2021 01:45 UTC](https://discourse.nodered.org/t/getting-specific-data-from-a-large-xml/39191/20 "2021-01-19T01:45:04Z")

</div>

It was a good challenge with Regular Expressions.  
Test it thoroughly though cause there could be some cases we missed (like that with the floats)

If you want to learn more about RegEx there is an interesting [video tutorial](https://www.youtube.com/watch?v=sa-TUpSx1JA) that covers many cases of the syntax

[Next page](https://discourse.nodered.org/t/getting-specific-data-from-a-large-xml/39191.md?page=2)