RegEx help

[JBurger]

I've been trying to understand the Regex in MS.

I have some text in a file

Code: Select all

May 12 2009 11:30:38
Temp pH   ORP  
79.0 8.00 427  
 CRX is ON  Auto
 KRX is OFF Auto
 OZN is OFF Auto
 HET is OFF Auto
 TPF is ON  Auto
 RFG is OFF Auto
 VOD is OFF Manual
 PMP is OFF Auto
 FPH is ON  Auto
 FMH is OFF Manual
 COL is OFF Auto
 MHL is OFF Auto
 MHC is OFF Auto
 MHR is OFF Auto
 VHO is ON  Auto
 SW1 is OFF Auto
 SW2 is OFF Auto
 MNT is OFF Auto
 VPH is OFF Auto
 ALM is OFF Auto
 PH1 is PF3 Auto
 PH2 is PF4 Auto
Power Failed: None
Power Restored: None

In my example I just want to find out the status of MHR if it is ON or OFF

Using regex that works for me in the past even the simple expression
MHR (.*.) Auto
gives me back the MHR line and everything after. I just need to capture the line or really just the ON or OFF status.

Here is what I am using right now

Code: Select all

Let>Pattern=MHR (.*.) Auto
Regex>%Pattern%,%var%,0,mres,num,0
Let>X=%mres_1%

Where var is the text info in the first section.

Any help would be great!

[gdyvig]

Hi JBurger,

I am new to regex also. Don't understand what the parens are for.

However. this works:

Let>Pattern=MHR is O[NF][F ]*Auto
Regex>%Pattern%,%var%,0,mres,num,0
Let>X=%mres_1%
MDL>(%X%)

Let>Pattern2=O[NF][F ]
Regex>%Pattern2%,%X%,0,mres2,num,0
Let>IGNORESPACES=1
Let>OnOff=%mres2_1%

MDL>(%OnOff%)


Gale

[Marcus Tettmar]

Or:

Code: Select all

Let>file=%USERDOCUMENTS_DIR%\stats.txt
ReadFile>file,data
Let>pattern=(?<=MHR is\s*)(ON|OFF)(?=\s*Auto)
RegEx>pattern,data,0,matches,num_matches,0
if>num_matches>0
  MessageModal>status=%matches_1%
Endif