Bookmarked Amit Agarwal (labnol.org)

Google Forms makes it relatively easy to add such advanced date validation rules to individual fields through Regular Expressions (or regex or regexp). Think of them as search patterns and every character entered in a form field is matched against that pattern – the form can only be submitted if the patter and the user-input matches.

Amit Agarwal provides a list of Regex formulas to use to validate data within Google Forms.
Bookmarked Remove HTML In Google Sheets Cells (Stack Overflow)

Trying to determine the best method to automatically remove HTML in all cells within a column in Google Sheets.

Example of cell data:

<span style=”color:#0000FF”>test</span>
I’d li…

After completing Ben Collins’ REGEX course, I wondered if it were possible to replace HTML with Markdown. I found the following REGEX formula for stripping out HTML:

=REGEXREPLACE(A1,"<[^<>]+>","")

I also found a ‘dirty’ converter code to run as a script.

However, I also found this post explaining why REGEX is not designed for parsing HTML:

Entire HTML parsing is not possible with regular expressions, since it depends on matching the opening and the closing tag which is not possible with regexps.

Regular expressions can only match regular languages but HTML is a context-free language and not a regular language (As @StefanPochmann pointed out, regular languages are also context-free, so context-free doesn’t necessarily mean not regular). The only thing you can do with regexps on HTML is heuristics but that will not work on every condition. It should be possible to present a HTML file that will be matched wrongly by any regular expression.

Replied to

Have started my climb up the Matterhorn. After watching just the first example I can already see how this is going to revolutionise many of my formulas. I just pray that I am not one of those bodies found in the ice years later.
RSVPed Attending The Google Sheets REGEX Formula Cookbook

Enhance your data skills and learn how to use the powerful REGEX formulas in Google Sheets

Completed Ben Collins’ course on REGEX. As always, I appreciated the way in which Collins’ unpacks different scenarios. The only thing that I would have been interested in more discussion of using REGEX within a QUERY.
Replied to

Now that would be a course worth paying for.
Replied to

I really need to get my head around REGEX.