The summary of ‘Google Sheets – RegEx REGEXEXTRACT, Functions Exctract, Replace, Match Tutorial – Part 2’

The video discusses using regular expressions to extract domain information from text data. The speaker demonstrates how to split text using specified characters like '@' and '-' and explains the importance of understanding domain extensions. They highlight the use of parentheses, square brackets, and escape characters to create comprehensive patterns for extracting domain names and extensions. The video emphasizes the significance of case sensitivity and showcases techniques for creating inclusive regular expressions that capture various domain name and extension configurations accurately.

00:00:00

In this segment of the video, the speaker demonstrates using a split function to separate text before and after a specified character, in this case the ‘@’ sign. By setting a pattern to match the text before and after the ‘@’ sign using regex expressions, they show how to split the data into two columns. The speaker explains the use of parentheses to group and extract specific parts of the text based on the pattern specified. Additionally, they discuss how to match and extract domain extensions, emphasizing the importance of understanding possible characters in domain names.

00:03:00

In this segment of the video, the speaker explains how to use square brackets in regular expressions to define acceptable characters, including both lower and upper case letters and hyphens. By specifying characters within the square brackets, the speaker demonstrates how to extract specific patterns following a certain character, such as @ or -. The use of the plus sign indicates one or more of the specified characters, while ranges like a to Z provide a concise way to include a wide range of characters. The importance of case sensitivity is highlighted, with examples showing how to include uppercase letters as well.

00:06:00

In this part of the video, the speaker discusses building a pattern to extract domain names without extensions. The pattern includes lowercase and uppercase letters (a to z), numbers (0 to 9), and hyphens for the domain name. For the extension, they use an escape character and focus on text characters (A to Z). The speaker outlines how to extract the domain name and extension separately using parentheses and escape characters to delineate each part. This approach ensures a comprehensive pattern for identifying domains and extensions accurately.

00:09:00

In this segment of the video, the speaker is explaining regular expressions for extracting domain extensions. They use a pattern to match specific characters, group them together using parentheses, and utilize the pipe symbol for an “either/or” condition. The speaker demonstrates how to create non-capturing groups within the regular expression by adding a question mark and a colon after the opening parentheses to prevent capturing unnecessary groups. The final regular expression searches for patterns starting with an @ sign followed by a combination of characters, numbers, and hyphens, and allows for two possible extension types.