Regular Expressions 101

Group transaction_date(?P<transaction_date>\d+/\d+)

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

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

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

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

Group description(?P<description>.*?)

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

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

Group amount(?P<amount>[\d.,]+)

Character Class[\d.,]+

+matches at least one character from the set below:

\da Unicode decimal digit

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

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

$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.

Search reference

Regular Expression

(?P<transaction_date>\d+/\d+)\s*(?P<description>.*?)\s*(?P<amount>[\d.,]+)$

New

06/07         URBAN TRANSIT CO.       SINGAPORE      SG      1.38
07/07         MORNING BITES CAFE      SINGAPORE      SG      4.20
13/07         SUNRISE TOAST HAVEN     SINGAPORE      SG      3.20

Regular Expression

Extraction