regex101: PCRE (Legacy) Match Workspace

Definition Group(?(DEFINE)(?'Row'(?:<\/td)?>[^>]+>))

Group Row(?'Row'(?:<\/td)?>[^>]+>)

Non-Capturing Group(?:<\/td)?

?repeats the group contents below at most once:

<the literal < (60₁₀ / 74₈ / 3C₁₆)

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

tdthe literal text td (case sensitive)

>the literal > (62₁₀ / 76₈ / 3E₁₆)

Negated Character Class[^>]+

+matches at least one character outside the set below:

>the literal > (62₁₀ / 76₈ / 3E₁₆)

^start of line

+the literal (32₁₀ / 40₈ / 20₁₆) , repeated at least once

<tr class="clickable" data-id="the literal text <tr class="clickable" data-id=" (case sensitive)

Group AccountID(?<AccountID>[^"]+)

Negated Character Class[^"]+

+matches at least one character outside the set below:

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

" data-jobid=the literal text " data-jobid= (case sensitive)

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

Group JobID(?<JobID>[^\"]+)

Negated Character Class[^\"]+

+matches at least one character outside the set below:

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

(?P>Row)calls group Row as a subroutine

Group InvoiceID(?<InvoiceID>[^<]+)

Negated Character Class[^<]+

+matches at least one character outside the set below:

<the literal < (60₁₀ / 74₈ / 3C₁₆)

(?P>Row)calls group Row as a subroutine

Group Date(?<Date>[^ ]+)

Negated Character Class[^ ]+

+matches at least one character outside the set below:

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

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

+the literal (32₁₀ / 40₈ / 20₁₆) , repeated at least once

(?P>Row)calls group Row as a subroutine

Group Status(?<Status>[^<]+)

Negated Character Class[^<]+

+matches at least one character outside the set below:

<the literal < (60₁₀ / 74₈ / 3C₁₆)

(?P>Row)calls group Row as a subroutine

Group Type(?<Type>[^<]+)

Negated Character Class[^<]+

+matches at least one character outside the set below:

<the literal < (60₁₀ / 74₈ / 3C₁₆)

(?P>Row)calls group Row as a subroutine

Group Total(?<Total>[^<]+)

Negated Character Class[^<]+

+matches at least one character outside the set below:

<the literal < (60₁₀ / 74₈ / 3C₁₆)

(?P>Row)calls group Row as a subroutine

Group Balance(?<Balance>[^<]+)

Negated Character Class[^<]+

+matches at least one character outside the set below:

<the literal < (60₁₀ / 74₈ / 3C₁₆)

(?P>Row)calls group Row as a subroutine

Group Paid(?<Paid>[^<]+)

Negated Character Class[^<]+

+matches at least one character outside the set below:

<the literal < (60₁₀ / 74₈ / 3C₁₆)

(?P>Row)calls group Row as a subroutine

Group Technician(?<Technician>[^<]+)

Negated Character Class[^<]+

+matches at least one character outside the set below:

<the literal < (60₁₀ / 74₈ / 3C₁₆)

(?P>Row)calls group Row as a subroutine

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

Search reference

Regular Expression

(?(DEFINE)(?'Row'(?:<\/td)?>[^>]+>))^ +<tr class="clickable" data-id="(?<AccountID>[^"]+)" data-jobid=\"(?<JobID>[^\"]+)\"(?P>Row)(?<InvoiceID>[^<]+)(?P>Row)(?<Date>[^ ]+)\n +(?P>Row)(?<Status>[^<]+)(?P>Row)(?<Type>[^<]+)(?P>Row)(?<Total>[^<]+)(?P>Row)(?<Balance>[^<]+)(?P>Row)(?<Paid>[^<]+)(?P>Row)(?<Technician>[^<]+)(?P>Row)

New


                        <th>Technician</th>
                        <th></th>
                    </tr>
                </thead>
                <tbody>
                                    <tr class="clickable" data-id="277928" data-jobid="3100878">
                        <td>3142140</td>
                        <td>07/21/2017
                                                    </td>
                        <td>Complete</td>
                        <td>Initial</td>
                        <td>$309.00</td>
                        <td>$316.76</td>
                        <td>No</td>
                        <td>John Smith</td>
                        <td>
                            <div class="btn-group pull-right">
                                <a class="btn btn-small dropdown-toggle" data-toggle="dropdown" href="javascript:;">Action <span class="caret"></span></a>
                                <ul class="dropdown-menu">

Regular Expressions 101

Regular Expression

Extraction