regex101: Python Substitution Workspace

Pro

^start of line

Group 1([^\d\n]+)

Negated Character Class[^\d\n]+

+matches at least one character outside the set below:

\da Unicode decimal digit

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

Group 2(\d[\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₁₆)

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

-the literal - (45₁₀ / 55₈ / 2D₁₆)

the literal (32₁₀ / 40₈ / 20₁₆)

\d+a Unicode decimal digit, repeated at least once

the literal (32₁₀ / 40₈ / 20₁₆)

\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₁₆)

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

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

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

Group 3((?:\n(?!.*\b\d[\d,.]*\.\d{2}$).*)*)

Non-Capturing Group(?:\n(?!.*\b\d[\d,.]*\.\d{2}$).*)*

*repeats the group contents below any number of times:

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

Negative Lookahead(?!.*\b\d[\d,.]*\.\d{2}$)

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

\ba Unicode word boundary

\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₁₆)

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

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

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

$end of line

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

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

25 tokens

Regular Expression

^([^\d\n]+)(\d[\d,.-]* \d+) \d[\d,.]*\.\d{2}((?:\n(?!.*\b\d[\d,.]*\.\d{2}$).*)*)

New

CATS THIRD PARTY PAYMENT 1,664.58 0320 2,130.05
MUTUAL/IBS /GAL /0000010318908
IB TRANSFER TO 2,000.00- 0323 130.05
578441575425   10H32 28662338
FEE-INTER ACCOUNT TRANSFER ## 5.50- 0323 124.55
8419752
IB PAYMENT FROM 9,000.00 0325 9,124.55
JENNIFER LIVINGSTONE
IB PAYMENT FROM 1,000.00 0401 10,124.55
JENNIFER LIVINGSTONE
MONTHLY MANAGEMENT FEE ## 21.00- 0331 10,103.55
CREDIT TRANSFER 9,000.00 0401 19,103.55
ABSA BANK rent
IB TRANSFER TO 19,000.00- 0403 103.55
578441575425   11H45 286623383

Extraction

CATS THIRD PARTY PAYMENT 1,664.58 0320 2,130.05
MUTUAL/IBS /GAL /0000010318908
IB TRANSFER TO 2,000.00- 0323 130.05
578441575425   10H32 28662338
FEE-INTER ACCOUNT TRANSFER ## 5.50- 0323 124.55
8419752
IB PAYMENT FROM 9,000.00 0325 9,124.55
JENNIFER LIVINGSTONE
IB PAYMENT FROM 1,000.00 0401 10,124.55
JENNIFER LIVINGSTONE
MONTHLY MANAGEMENT FEE ## 21.00- 0331 10,103.55
CREDIT TRANSFER 9,000.00 0401 19,103.55
ABSA BANK rent
IB TRANSFER TO 19,000.00- 0403 103.55
578441575425   11H45 286623383