Search code examples
regexphpmyadminsublimetext3

Removing entire tags containing a specific term using regex

I am altering a database with approximately 500 html pages using phpmyadmin. Several pages contain a Facebook Pixel or Google Tag that I would like to remove.

The easiest way I thought would be to search via regex the entire tag that contains some expression or term related to Facebook or Google, and replace it with blank.

An example would be

<script>
    window.dataLayer = window.dataLayer || [];

    function gtag() {
      dataLayer.push(arguments);
    }
    gtag('js', new Date());
    gtag('config', 'G-XXXXXXXX');
  </script>

or

<script>
    (window, document, 'script', 'https://connect.facebook.net/en_US/fbevents.js');
    fbq('init', '9999999999999999');
    fbq('track', 'salespage_xxxxxx');
  </script>

Although all are unique, some have the same code or another element that makes it possible to identify each one of them.

Before running in myphpadmin, I'm trying to formulate the expression using SublimeText3

It's the first contact I have with the regex and I found it fascinating, but even following some references I can't match the search.

The expression I came up with after some research was

<(.*)>[\s\S]face[\s\S]<\/(.*)>

Where I thought the expression would select the entire tag containing the word "face", but it doesn't find anything.

I would like some help.

If it works, it would be able to make several other necessary changes.

Solution

  • This regex expression will match the <script> tag that contains the face keyword

    <(script)>(?:(?!<\/\1>|face)[\s\S])+face(?:(?!<\/\1>)[\s\S])+<\/\1>

    See example: https://regex101.com/r/LfRlBV/1