Regular Expressions 101

Pro

Group 1(.+\"entrytimestamp\"\s:\s)

.+any character (except for line terminators), repeated at least once

\"the literal " (34₁₀ / 42₈ / 22₁₆)

entrytimestampthe literal text entrytimestamp (case sensitive)

\"the literal " (34₁₀ / 42₈ / 22₁₆)

\sany whitespace character

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

\sany whitespace character

ISODatethe literal text ISODate (case sensitive)

\(the literal ( (40₁₀ / 50₈ / 28₁₆)

Group 2(\"[0-9]{4}-[0-9]{2}-[0-9]{2}T[0-9]{2}:[0-9]{2}:[0-9]{2}\.[0-9]{1,3}Z\")

\"the literal " (34₁₀ / 42₈ / 22₁₆)

Character Class[0-9]{4}

{4}matches exactly 4 characters from the set below:

0-9one character from 0 (48₁₀) to 9 (57₁₀)

-the literal - (45₁₀ / 55₈ / 2D₁₆)

Character Class[0-9]{2}

{2}matches exactly 2 characters from the set below:

0-9one character from 0 (48₁₀) to 9 (57₁₀)

-the literal - (45₁₀ / 55₈ / 2D₁₆)

Character Class[0-9]{2}

{2}matches exactly 2 characters from the set below:

0-9one character from 0 (48₁₀) to 9 (57₁₀)

Tthe literal T (84₁₀ / 124₈ / 54₁₆) (case sensitive)

Character Class[0-9]{2}

{2}matches exactly 2 characters from the set below:

0-9one character from 0 (48₁₀) to 9 (57₁₀)

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

Character Class[0-9]{2}

{2}matches exactly 2 characters from the set below:

0-9one character from 0 (48₁₀) to 9 (57₁₀)

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

Character Class[0-9]{2}

{2}matches exactly 2 characters from the set below:

0-9one character from 0 (48₁₀) to 9 (57₁₀)

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

Character Class[0-9]{1,3}

{1,3}matches between 1 and 3 characters from the set below:

0-9one character from 0 (48₁₀) to 9 (57₁₀)

Zthe literal Z (90₁₀ / 132₈ / 5A₁₆) (case sensitive)

\"the literal " (34₁₀ / 42₈ / 22₁₆)

\)the literal ) (41₁₀ / 51₈ / 29₁₆)

Group 3(.*)

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

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

Regular Expression

(.+\"entrytimestamp\"\s:\s)ISODate\((\"[0-9]{4}-[0-9]{2}-[0-9]{2}T[0-9]{2}:[0-9]{2}:[0-9]{2}\.[0-9]{1,3}Z\")\)(.*)

New

root@# cat inar.json
[
        {
                "_id" : ObjectId("5f58fdc632e4de001621c1ca"),
                "USER" : null,
                "entrytimestamp" : ISODate("2020-09-09T16:07:34.526Z")
        },
        {
                "_id" : ObjectId("5f590118c205630016dcafb4"),
                "entrytimestamp" : ISODate("2020-09-09T16:21:44.346Z"),
                "USER" : null
        }
]

Substitution

\1\2\3

root@# cat inar.json
[
        {
                "_id" : ObjectId("5f58fdc632e4de001621c1ca"),
                "USER" : null,
                "entrytimestamp" : ISODate("2020-09-09T16:07:34.526Z")
        },
        {
                "_id" : ObjectId("5f590118c205630016dcafb4"),
                "entrytimestamp" : ISODate("2020-09-09T16:21:44.346Z"),
                "USER" : null
        }
]