Regular Expressions 101

Explanation

Pro

Group 1([^\v\t]+)

Negated Character Class[^\v\t]+

+matches at least one character outside the set below:

\vany vertical whitespace character

\ta tab character (ASCII 9)

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

Group 2([^\v\t]+)

Negated Character Class[^\v\t]+

+matches at least one character outside the set below:

\vany vertical whitespace character

\ta tab character (ASCII 9)

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

Group 3([^\v\t]+)

Negated Character Class[^\v\t]+

+matches at least one character outside the set below:

\vany vertical whitespace character

\ta tab character (ASCII 9)

Group 4([\v\t]+|Loading transaction details for|[\v\t]+\1){0,3}

{0,3}repeats the group contents below between 0 and 3 times:

1st Alternative[\v\t]+

Character Class[\v\t]+

+matches at least one character from the set below:

\vany vertical whitespace character

\ta tab character (ASCII 9)

2nd AlternativeLoading transaction details for

Loading transaction details forthe literal text Loading transaction details for (case sensitive)

3rd Alternative[\v\t]+\1

Character Class[\v\t]+

+matches at least one character from the set below:

\vany vertical whitespace character

\ta tab character (ASCII 9)

\1the text saved by group 1

Global pattern flags

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

Match Information

Detailed match information will be displayed here automatically.

Quick Reference

25 tokens

Regular Expression

([^\v\t]+)\s*([^\v\t]+)\s*([^\v\t]+)([\v\t]+|Loading transaction details for|[\v\t]+\1){0,3}

New


Google
- negative$4.99
Jun 21Automatic Payment
Google
- negative$4.99
Jun 21Automatic Payment
Loading transaction details for
Google
- negative$4.99
Jun 21Automatic Payment

Extraction


Google
- negative$4.99
Jun 21Automatic Payment
Google
- negative$4.99
Jun 21Automatic Payment
Loading transaction details for
Google
- negative$4.99
Jun 21Automatic Payment