Regular Expressions 101

Pro

^start of line

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

Non-Capturing Group(?:null)?

?repeats the group contents below at most once:

nullthe literal text null (case sensitive)

\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})?(\s+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₁₆)

Non-Capturing Group(?:\.\d{2})?

?repeats the group contents below at most once:

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

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

Group 4(\s+Cr)?

?repeats the group contents below at most once:

\s+a Unicode whitespace character, repeated at least 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*(?:null)?\s*(\d{2}/\d{2}/\d{4})\s+(.*?)\s+(\d[\d,]*(?:\.\d{2})?(\s+Cr)?)$

New

 null 12/05/2016 Asian Paints 2,150.65
   13/05/2016 Nerolac GEB 5.86 22,512.65 Cr
14/05/2016 Hydra 12,412

 null 12/05/2016 Asian Paints 2,150.65
   13/05/2016 Nerolac GEB 5.86 22,512.65 Cr
14/05/2016 Hydra 12,412