Regular Expressions 101

^start of line

Group 1(\s\w|\s\s)

1st Alternative\s\w

\sany whitespace character

\wany word character

2nd Alternative\s\s

\sany whitespace character

\s{2}any whitespace character, repeated exactly 2 times

Group 2(\w{2}\d{2}PRI)

\w{2}any word character, repeated exactly 2 times

\d{2}a digit, repeated exactly 2 times

PRIthe literal text PRI (case sensitive)

Group 3((?:\s+\d+)+)

Non-Capturing Group(?:\s+\d+)+

+repeats the group contents below at least once:

\s+any whitespace character, repeated at least once

\d+a digit, repeated at least once

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

^(\s\w|\s\s)\s{2}(\w{2}\d{2}PRI)((?:\s+\d+)+)

Test String
New

   Device       FT01PRI    FT02PRI    FT03PRI    FV01PRI    FV02PRI  

 F  AD01PRI         0          0          0          0          0    
 R  CX01PRI         0          3          0          3          6    
 O  CX02PRI         2          2          1          0          0    
 M  CX03PRI         2          0          1          1          6    
    DA01PRI         0          0          0          0          0    
    DA02PRI         6          0          0          0          0    
    DB01PRI         0          0          0          0          0

Regular Expression

Test StringNew

SubstitutionProcessing...

Test String
New

Substitution
Processing...