regex101: PCRE (Legacy) Match Workspace

^start of line

\h*any horizontal whitespace character, repeated any number of times

<tdthe literal text <td (case sensitive)

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

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

Group 1([^<\r\n]+)

Negated Character Class[^<\r\n]+

+matches at least one character outside the set below:

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

\ra carriage return (ASCII 13)

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

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

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

tdthe literal text td (case sensitive)

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

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

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

<tdthe literal text <td (case sensitive)

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

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

Group 2([^<\r\n]+)

Negated Character Class[^<\r\n]+

+matches at least one character outside the set below:

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

\ra carriage return (ASCII 13)

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

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

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

tdthe literal text td (case sensitive)

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

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

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

^\h*<td\s*>([^<\r\n]+)<\/td\s*>.*<td\s*>([^<\r\n]+)<\/td\s*>

New

<tr >

     <th style="text-align:right; background-color:white; color:black" scope="col">Rank</th>

     <th style="text-align:right; background-color:white; color:black" scope="col" abbr="male name">Name</th>

     <th style="text-align:right; background-color:white; color:black" scope="col" abbr="male number">Number</th>

     <th style="text-align:right; background-color:white; color:black"  scope="col" abbr="female name">Name</th>

     <th style="text-align:right; background-color:white; color:black"  abbr="female number">Number</th>

   </tr>

   </thead>

   <tbody>

<tr ><td>1</td>

  <td >Jacob</td> <td>273,844</td> <td >Emily</td> <td>223,690</td></tr>

<tr ><td>2</td>

  <td >Michael</td> <td>250,554</td> <td >Madison</td> <td>193,152</td></tr>

<tr ><td>3</td>

  <td >Joshua</td> <td>231,926</td> <td >Emma</td> <td>181,257</td></tr>

<tr ><td>4</td>

  <td >Matthew</td> <td>221,513</td> <td >Olivia</td> <td>156,000</td></tr>

<tr ><td>5</td>

Regular Expressions 101

Regular Expression

Extraction