Merge same parameters in XML file

[Petr Andreev]

Hi

How I can make from this data
<param name=“Product”>Multifunction valves</param>
<param name=“Coolant”>R113</param>
<param name=“Coolant”>R114</param>
<param name=“Coolant”>R1233zd(E)</param>
<param name=“Coolant”>R1234yf</param>
<param name=“Coolant”>R1234ze(E)</param>
<param name=“Coolant”>R125</param>
<param name=“Coolant”>R1270</param>
<param name=“Coolant”>R1336mzz(Z)</param>
<param name=“Coolant”>R134a</param>
<param name=“Coolant”>R152a</param>
<param name=“Coolant”>R170</param>
<param name=“Coolant”>R22</param>

like this
<param name=“Product”>Multifunction valves</param>
<param name=“Coolant”>R113; R114; R1233zd(E); R1234yf; R1234ze(E); R125; R1270; R1336mzz(Z); R134a; R152a; R170; R22</param>

[guy038]

Hello, @petr-andreev,

No problem with regular expressions !

Here are the few steps to do :

• Go back at the very beginning of your document ( Ctrl + Origin )

• Open the Replace dialog ( Ctrl + H )

• SEARCH (?-is)</param>\R<param name="Coolant">|^(.+Product.+?);\x20

• REPLACE (?1\1</param>\r\n<param name="Coolant">:;\x20)

• UNcheck the Wrap around option, if necessary

• Select the Regular expression search mode

• Click TWICE, on the REplace All button

Et voilà !

At first sight, you may think that these regexes are complicated, But I tried to give some information on them, in the Notes section, below !

---

So, from your original text, below :

<param name="Product">Multifunction valves</param>
<param name="Coolant">R113</param>
<param name="Coolant">R114</param>
<param name="Coolant">R1233zd(E)</param>
<param name="Coolant">R1234yf</param>
<param name="Coolant">R1234ze(E)</param>
<param name="Coolant">R125</param>
<param name="Coolant">R1270</param>
<param name="Coolant">R1336mzz(Z)</param>
<param name="Coolant">R134a</param>
<param name="Coolant">R152a</param>
<param name="Coolant">R170</param>
<param name="Coolant">R22</param>

You get, after TWO clicks on the Replace All button, your wanted text, below ;-))

<param name="Product">Multifunction valves</param>
<param name="Coolant">R113; R114; R1233zd(E); R1234yf; R1234ze(E); R125; R1270; R1336mzz(Z); R134a; R152a; R170; R22</param>

---

Notes,

• The modifiers (?-is) forces a sensitive way of search and the special dot character will match a single standard character, only !

• Then, due to the alternative symbol ( | ), the regex engine looks for, either :

  • Case A The string </param>, followed by End of Line character(s) and ending with the string <param name=“Coolant”> ( part </param>\R<param name="Coolant"> )

  • Case B The string, located between a beginning of line and the first semicolon ;, containing the string Product ( part ^(.+Product.+?); ), followed by a space character ( part \x20 )

• In replacement, it rewrites, either :

  • Case A A semicolon, followed by a space character ( part ;\x20 ), which is the ELSE part of the conditional replacement, located after the colon symbol :

  • Case B The group 1 ( The string from beginning of line, till a semicolon character, excluded, containing the string Product ( part \1 ), followed by the string </param>, a line break and the string <param name=“Coolant”> ( part </param>\r\n<param name="Coolant"> )
    It is the THEN part of the conditional replacement, located between the (?1 syntax and the colon symbol :

---

Remarks :

• Case A occurs first, because there’s no semicolon symbol ( ; ), in your original text !

• Of course, in these regexes, you may change the tags Product and Coolant, as you like to :-)

Best Regards,

guy038