regex101: Python Match Workspace

(?s)applies the following effective flags to the remainder of the pattern: gms

s modifier: single line. Allows a dot to match line terminators

PROC DATE:the literal text PROC DATE: (case sensitive)

\s*a Unicode whitespace character, repeated any number of times

Group date(?P<date>\w+)

\w+a Unicode word character, repeated at least once

Non-Capturing Group(?:(?!RID:\s+RSS-\d|ACQT).)*

*repeats the group contents below any number of times:

Negative Lookahead(?!RID:\s+RSS-\d|ACQT)

1st AlternativeRID:\s+RSS-\d

RID:the literal text RID: (case sensitive)

\s+a Unicode whitespace character, repeated at least once

RSS-the literal text RSS- (case sensitive)

\da Unicode decimal digit

2nd AlternativeACQT

ACQTthe literal text ACQT (case sensitive)

.any Unicode character

ACQTthe literal text ACQT (case sensitive)

Non-Capturing Group(?:(?!RID:\s+RSS-\d).)*

*repeats the group contents below any number of times:

Negative Lookahead(?!RID:\s+RSS-\d)

RID:the literal text RID: (case sensitive)

\s+a Unicode whitespace character, repeated at least once

RSS-the literal text RSS- (case sensitive)

\da Unicode decimal digit

.any Unicode character

T PURthe literal text T PUR (case sensitive)

\s+a Unicode whitespace character, repeated at least once

Group num(?P<num>\d[.,\d]*)

\da Unicode decimal digit

Character Class[.,\d]*

*matches any number of characters from the set below:

.the literal . (46₁₀ / 56₈ / 2E₁₆)

,the literal , (44₁₀ / 54₈ / 2C₁₆)

\da Unicode decimal digit

\s+a Unicode whitespace character, repeated at least once

Group val(?P<val>\d[\d,]*)

\da Unicode decimal digit

Character Class[\d,]*

*matches any number of characters from the set below:

\da Unicode decimal digit

,the literal , (44₁₀ / 54₈ / 2C₁₆)

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

Search reference

Regular Expression

(?s)PROC DATE:\s*(?P<date>\w+)(?:(?!RID:\s+RSS-\d|ACQT).)*ACQT(?:(?!RID:\s+RSS-\d).)*T PUR\s+(?P<num>\d[.,\d]*)\s+(?P<val>\d[\d,]*)

New

RID:  RSS-130                                         SERVICE                        PAGE:              2   
REPORTING FOR:      100019912 SSSE                      INTSERVICE                    PROC DATE:   15SEP21   
ROLLUP FOR:          100076212 SSSE                          REPORT                        REPORT DATE: 15SEP21   
ENTITY:  1000208212 SSSE                                                                                                 
                                                                                                                                      
                                                                                                                                      
   T PUR                                              70            1,346,001             1,348.5                                                                                                                                      
                                                                                                                                      
 ACQT                                                                                                               
                                                                                                                                      
                                                                                                                                      
   PUR                                                                                                                         
     SAME                      10SEP21                 120            12,263,518             19,48.5                        
                                                                                                                                      
   T PUR                                              120            12,263,518             19,48.5