Regular Expressions 101

Positive Lookbehind(?<=Code:)

Code:the literal text Code: (case sensitive)

.*any character (except for line terminators), repeated any number of times

Distributionthe literal text Distribution (case sensitive)

\sany whitespace character

Group 1([\d.,]+)

Character Class[\d.,]+

+matches at least one character from the set below:

\da digit

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

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

Positive Lookahead(?=\n)

\na line-feed (newline) character (ASCII 10)

Global pattern flags

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

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

(?<=Code:).*Distribution\s([\d.,]+)(?=\n)

Test String
New

Code: 210 - Test 1 - Distribution
267745 Vis - Branch Deposit 3/10/2021 2,000.00
468040 v- Branch Deposit 2/10/2021 1,700.00
586075 Visa 3/3/2021 555.48
502490 Vis 3/4/2021 1,835.51
403195 Vis 3/4/2021 2,033.56
500230 Vis 3/4/2021 651.29

Code: 210 - Test - Distribution 8,775.84
Code: 230 - Greenville - Distribution
853955 Clearing 2/1/2021 77.50

Regular Expression

Test StringNew

ExtractionProcessing...

Test String
New

Extraction
Processing...