Regular Expressions 101

Pro

Group 1(\[[^\[\]\r\n]*\])

\[the literal [ (91₁₀ / 133₈ / 5B₁₆)

Negated Character Class[^\[\]\r\n]*

*matches any number of characters outside the set below:

\[the literal [ (91₁₀ / 133₈ / 5B₁₆)

\]the literal ] (93₁₀ / 135₈ / 5D₁₆)

\ra carriage return (ASCII 13)

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

\]the literal ] (93₁₀ / 135₈ / 5D₁₆)

:the literal : (58₁₀ / 72₈ / 3A₁₆)

Group 2({.*?})

{the literal { (123₁₀ / 173₈ / 7B₁₆)

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

}the literal } (125₁₀ / 175₈ / 7D₁₆)

Non-Capturing Group(?: (?=\[)|$)

1st Alternative (?=\[)

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

Positive Lookahead(?=\[)

\[the literal [ (91₁₀ / 133₈ / 5B₁₆)

2nd Alternative$

$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

(\[[^\[\]\r\n]*\]):({.*?})(?: (?=\[)|$)

New

[row1|col1]:{value:{{calculate}}<<report_1>>[Row2|col2];format:float;} [hiddenr0120a|c0012]:{format:float;}