<div dir="ltr"><div><div><div><div><div><div><div><div>Jesse,<br><br></div>I've created an example here : <a href="https://regex101.com/r/iZ5jO8/1">https://regex101.com/r/iZ5jO8/1</a>. This should really help understanding how I'm getting the result, by decomposing each step of the regex.<br><br></div>Note that I added names to capturing groups, you don't have to do that, you could use just positional:<br><br>Look for: (SYSTEM *\n *?TYPE *= )HP(.*?FURNACE-HIR +?= [.0-9]+)\n(.*?\.\.\n)(\".*?\")<br><br></div><div>Replace with: \1PSZ\2\n CONTROL-ZONE = \4\n\3\4<br></div><div><br></div>A few things: dot (.) has to match newline characters for it to work.<br></div>Also, in notepad++ to replace with named capturing groups, you use $+{Name}<br></div>You have to replace \n (unix convention) by \r\n.<br><br><br></div>Anyways, for notepad++ try:<br><br></div>Search:<br>(?<System1>SYSTEM *\r\n *?TYPE *= )HP(?<System2>.*?FURNACE-HIR +?= [.0-9]+)\r\n(?<System3>.*?\.\.\r<br>\n)(?<ZoneName>\".*?\")<br><br></div>Replace with:<br>$+{System1}PSZ$+{System2}\n CONTROL-ZONE = $+{ZoneName}\n$+{System3}$+{ZoneName}<br><div><div><div><br><div><div><br><br></div><div>I've loaded it up in eQuest, seems to do the job just fine. Let me know if you are trouble implementing. I've also attached the file back, but I'd be a shame to not take this as an opportunity to learn regex<br><br></div><div>PS: By the way, you should really use floor multipliers.<br><br></div><div>Best,<br></div><div>Julien<br></div><div><br></div></div></div></div></div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><div>--<br>Julien Marrec, EBCP, BPI MFBA<br>Energy&Sustainability Engineer<br>T: +33 6 95 14 42 13<br><span style="color:rgb(0,0,0)"><br></span><span style="color:rgb(0,0,0)">LinkedIn (en) : <span style="color:rgb(0,0,0)"><a href="http://www.linkedin.com/in/julienmarrec" target="_blank">www.linkedin.com/in/julienmarrec</a><br></span>LinkedIn (fr) : <a href="http://www.linkedin.com/in/julienmarrec/fr" target="_blank">www.linkedin.com/in/julienmarrec/fr</a></span><br><span style="color:rgb(0,0,0)"><a href="http://www.linkedin.com/in/julienmarrec" target="_blank"></a></span></div></div></div></div>
<br><div class="gmail_quote">2015-09-09 22:32 GMT+02:00 Phillips, Jesse <span dir="ltr"><<a href="mailto:jphillips@rdkengineers.com" target="_blank">jphillips@rdkengineers.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Thanks Julien.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">I’ve attached the inp file. I am not familiar with Regex at all but I’ll check out that website. If you could send me some examples tomorrow though, that would
be great!<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">thanks,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Jesse<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Julien Marrec [mailto:<a href="mailto:julien.marrec@gmail.com" target="_blank">julien.marrec@gmail.com</a>]
<br>
<b>Sent:</b> Wednesday, September 09, 2015 4:27 PM<br>
<b>To:</b> Phillips, Jesse <jphillips@RDKEngineers.com><br>
<b>Cc:</b> Nathan Miller <<a href="mailto:nathanm@rushingco.com" target="_blank">nathanm@rushingco.com</a>>; <a href="mailto:equest-users@lists.onebuilding.org" target="_blank">equest-users@lists.onebuilding.org</a><br>
<b>Subject:</b> Re: [Equest-users] eQuest & NoteTab Question<u></u><u></u></span></p><div><div class="h5">
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Hi,<u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">I don't know Notetab, but as long as you have one system for each zone, this is pretty easy if your editor supports Regular Expressions (Regex).<u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">As you might know, inp files has what I call a positional input for a few things (space > surface > window/door, same for system > zone). Meaning if you find something that is a system, everything that's right
after (which are zones) below to this system until you find another system. As opposed to having a keyword linking those two objects.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">So you could use a regex for this job. Especially using positive lookaheads to delimit a single system and its zone (singular here, could be plural).<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">If you do have only a single zone per system, it's even easier.<br>
<br>
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Just look for a system and it's zone below it.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">If you are not familiar with regex and can't manage to build it, let me know, I'll try to find a few tomorrow to help you out (send me your file or an extract or it so I don't have to create a dummy one to play
with it).<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">By the way, here's a website I wish existed when I first started playing with regex:
<a href="https://regex101.com/" target="_blank">https://regex101.com/</a>. Fyi, Notepad++ uses the prce engine.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Cheers,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Julien<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
<div>
<p class="MsoNormal"><br clear="all">
<u></u><u></u></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal">--<br>
Julien Marrec, EBCP, BPI MFBA<br>
Energy&Sustainability Engineer<br>
T: <a href="tel:%2B33%206%2095%2014%2042%2013" value="+33695144213" target="_blank">+33 6 95 14 42 13</a><br>
<span style="color:black"><br>
LinkedIn (en) : <a href="http://www.linkedin.com/in/julienmarrec" target="_blank">
www.linkedin.com/in/julienmarrec</a><br>
LinkedIn (fr) : <a href="http://www.linkedin.com/in/julienmarrec/fr" target="_blank">
www.linkedin.com/in/julienmarrec/fr</a></span><u></u><u></u></p>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">2015-09-09 22:04 GMT+02:00 Phillips, Jesse <<a href="mailto:jphillips@rdkengineers.com" target="_blank">jphillips@rdkengineers.com</a>>:<u></u><u></u></p>
<blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<p class="MsoNormal"><span style="color:#1f497d">I don’t think you can create macros in NoteTab. What would that macro look like in boxer?</span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:#1f497d"> </span><u></u><u></u></p>
<div>
<p class="MsoNormal"><span style="color:#1f497d">Jesse Phillips</span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:#1f497d">Energy Engineer</span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:#1f497d">RDK Engineers</span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:#1f497d">P: 857-221-5957</span><u></u><u></u></p>
</div>
<p class="MsoNormal"><span style="color:#1f497d"> </span><u></u><u></u></p>
<div>
<div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Nathan Miller [mailto:<a href="mailto:nathanm@rushingco.com" target="_blank">nathanm@rushingco.com</a>]
<br>
<b>Sent:</b> Wednesday, September 09, 2015 3:38 PM<br>
<b>To:</b> Phillips, Jesse <<a href="mailto:jphillips@RDKEngineers.com" target="_blank">jphillips@RDKEngineers.com</a>>;
<a href="mailto:equest-users@lists.onebuilding.org" target="_blank">equest-users@lists.onebuilding.org</a><br>
<b>Subject:</b> RE: eQuest & NoteTab Question<u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal"><span style="color:#1f497d">Can you create a macro that searches for each instance of “=ZONE”, copies the text before the “=” to get the zone name, and the pastes in the lines necessary
to create a new single zone system, using the zone name now stored in the clip-board to paste in the control zone?
</span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:#1f497d"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:#1f497d">I’m not familiar with NoteTab, but you can do that in boxer.
</span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:#1f497d"> </span><u></u><u></u></p>
<div>
<p class="MsoNormal" style="margin-top:1.0pt"><b><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#632423"> </span></b><u></u><u></u></p>
<p class="MsoNormal" style="margin-bottom:4.0pt"><b><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:#6f1200">Nathan Miller, PE, LEED AP BD+C</span></b><b><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:#632423">
– </span></b><i><span style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:black">Mechanical Engineer/Senior Energy Analyst</span></i><u></u><u></u></p>
<p class="MsoNormal" style="margin-top:3.0pt;line-height:115%">
<b><span style="font-size:8.0pt;line-height:115%;font-family:"Verdana",sans-serif;color:#6f1200">RUSHING</span></b><span style="font-size:8.0pt;line-height:115%;font-family:"Verdana",sans-serif;color:#bfab7f">
</span><span style="font-size:8.0pt;line-height:115%;font-family:"Verdana",sans-serif;color:black">|
</span><b><span style="font-size:8.0pt;line-height:115%;font-family:"Verdana",sans-serif;color:#6f1200">D</span></b><span style="font-size:8.0pt;line-height:115%;font-family:"Verdana",sans-serif;color:#bfab7f">
</span><span style="font-size:8.0pt;line-height:115%;font-family:"Verdana",sans-serif;color:black">206-788-4577 |</span><span style="font-size:8.0pt;line-height:115%;font-family:"Verdana",sans-serif;color:#bfab7f">
</span><b><span style="font-size:8.0pt;line-height:115%;font-family:"Verdana",sans-serif;color:#6f1200">O</span></b><span style="font-size:8.0pt;line-height:115%;font-family:"Verdana",sans-serif;color:#a50021">
</span><span style="font-size:8.0pt;line-height:115%;font-family:"Verdana",sans-serif;color:black">206-285-7100</span><u></u><u></u></p>
<p class="MsoNormal" style="line-height:115%">
<b><span style="font-size:8.0pt;line-height:115%;font-family:"Verdana",sans-serif;color:#6f1200"><a href="http://www.rushingco.com/" target="_blank"><span style="color:#6f1200">www.rushingco.com</span></a></span></b><u></u><u></u></p>
</div>
<p class="MsoNormal"><span style="color:#1f497d"> </span><u></u><u></u></p>
<div>
<div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Equest-users [<a href="mailto:equest-users-bounces@lists.onebuilding.org" target="_blank">mailto:equest-users-bounces@lists.onebuilding.org</a>]
<b>On Behalf Of </b>Phillips, Jesse<br>
<b>Sent:</b> Wednesday, September 09, 2015 3:23 PM<br>
<b>To:</b> <a href="mailto:equest-users@lists.onebuilding.org" target="_blank">equest-users@lists.onebuilding.org</a><br>
<b>Subject:</b> [Equest-users] eQuest & NoteTab Question<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">Hi,<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">I have a model with 233 zones. Right now, every zone has a water loop heat pump. I want to convert these all to packaged single zone systems. To do this, I am working in the
.inp file and doing a “find and replace” in NoteTab. The replacing of the system type is easy. I simply search for the “type = HP” line and replace with “type = PSZ”. However, the PSZ system requires a control zone. I would like each control zone
to be the zone in which that particular system resides. Which means, for each of my 233 zones, I will have a different control zone (i.e. no longer a simple find and replace search).<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">Does anyone know of a way to use “find and replace” (or another method) to set each control zone with the zone name which the system resides?<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">This is what the .inp file should look like for a packaged single zone system:<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;background:yellow">"EL1 Sys1 (PTAC) (G.SSW1)" = SYSTEM</span><span style="font-size:10.0pt">
</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> TYPE = PSZ</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> HEAT-SOURCE = HEAT-PUMP</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> ZONE-HEAT-SOURCE = NONE</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> SIZING-RATIO = 1</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> COOL-SIZING-RATI = 1</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> MIN-SUPPLY-T = 58</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> FAN-SCHEDULE = "S1 Sys1 (PTAC) Fan Sch"</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> CW-LOOP = "DEFAULT-CW"</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> COOLING-CAPACITY = 15752</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> COOL-SH-CAP = 11839</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> HP-SUPP-SOURCE = NONE</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> FURNACE-HIR = 1.24067</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt">
<span style="background:yellow">CONTROL-ZONE = "EL1 SSW Perim Zn (G.SSW1)"</span></span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> C-EER95 = 8.24</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> C-COP47 = 0.78</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> C-AFUE = 0.78</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> C-SF-MTR-TYPE = 1</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> C-RF-MTR-TYPE = 1</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> C-OSA-DMPR-CTRL = 1</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> C-HTG-DUCT-LOCN = *Ceiling Plenum*</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> C-HTG-DUCT-RVAL = 7</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> C-CLG-DUCT-LOCN = *Ceiling Plenum*</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> C-CLG-DUCT-RVAL = 7</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> C-CLG-CAP-CATEG = 14</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> </span><u></u><u></u></p>
<p class="MsoNormal">For my next system, everything would be exactly the same except the highlighted lines (and so on for all 233 systems):<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;background:yellow">"EL1 Sys1 (PTAC) (G.W2)" = SYSTEM</span><span style="font-size:10.0pt">
</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> TYPE = PSZ</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> HEAT-SOURCE = HEAT-PUMP</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> ZONE-HEAT-SOURCE = NONE</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> SIZING-RATIO = 1</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> COOL-SIZING-RATI = 1</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> MIN-SUPPLY-T = 58</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> FAN-SCHEDULE = "S1 Sys1 (PTAC) Fan Sch"</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> CW-LOOP = "DEFAULT-CW"</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> COOLING-CAPACITY = 15752</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> COOL-SH-CAP = 11839</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> HP-SUPP-SOURCE = NONE</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> FURNACE-HIR = 1.24067</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt">
<span style="background:yellow">CONTROL-ZONE = "EL1 Sys1 (PTAC) (G.W2)"</span></span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> C-EER95 = 8.24</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> C-COP47 = 0.78</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> C-AFUE = 0.78</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> C-SF-MTR-TYPE = 1</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> C-RF-MTR-TYPE = 1</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> C-OSA-DMPR-CTRL = 1</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> C-HTG-DUCT-LOCN = *Ceiling Plenum*</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> C-HTG-DUCT-RVAL = 7</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> C-CLG-DUCT-LOCN = *Ceiling Plenum*</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> C-CLG-DUCT-RVAL = 7</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"> C-CLG-CAP-CATEG = 14</span><u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">thank you,<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none">
<span style="color:#1f497d">Jesse Phillips | Energy Engineer</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"> <u></u><u></u></p>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><u></u> <u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
_______________________________________________<br>
Equest-users mailing list<br>
<a href="http://lists.onebuilding.org/listinfo.cgi/equest-users-onebuilding.org" target="_blank">http://lists.onebuilding.org/listinfo.cgi/equest-users-onebuilding.org</a><br>
To unsubscribe from this mailing list send a blank message to <a href="mailto:EQUEST-USERS-UNSUBSCRIBE@ONEBUILDING.ORG" target="_blank">
EQUEST-USERS-UNSUBSCRIBE@ONEBUILDING.ORG</a><u></u><u></u></p>
</blockquote>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div></div></div>
<br><br></div>
</blockquote></div><br></div>