Regular Expressions 101

Pro

^start of line

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

Group 1(\d{2}/\d{2}/\d{4})

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

/the literal / (47₁₀ / 57₈ / 2F₁₆)

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

/the literal / (47₁₀ / 57₈ / 2F₁₆)

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

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

Group 2(.*?)

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

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

Group 3(\d[\d,]*\.\d{2}(?: Cr)?)

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

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

Non-Capturing Group(?: Cr)?

?repeats the group contents below at most once:

Crthe literal text Cr (case sensitive)

$end of line

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.

25 tokens

^\s*(\d{2}/\d{2}/\d{4})\s+(.*?)\s+(\d[\d,]*\.\d{2}(?: Cr)?)$

New

Date       Description    Amount
13/03/2021    XYZ ABC 428.00 31,408.37 Cr
17/03/2021    ZOOM.US 111-222-333 WWW.ZOOM.U USD 5.29 841.18