It allows you to apply more specific filter conditions. The REGEXMATCH function is also helpful when you want to filter your data set and in any spreadsheet formulas that need logical tests. This can be done by using “\d” as the regular expression which stands for digits.Īdding “\d” can be a useful way to see what page titles pulled from the SERPs contain numbers: The following REGEXMATCH function checks whether the input strings contain numbers. Read more about search intent analysis → More REGEXMATCH Formula Examples =if(REGEXMATCH(A2,"buy|Buy|price|Price|cost|Cost|pricing|Pricing|cheap|Cheap"),"Transactional",if(REGEXMATCH(A2,"how|How|what|What|why|Why|when|When|why|Why|can|Can|do"),"Informational",if(REGEXMATCH(A2,"best|Best|vs|Vs"),"Commercial Investigation", if(REGEXMATCH(A2,"real estate|rentals|estate agent|for sale"),"Navigational","Other")))) You can actually use the REGEXMATCH formula to perform basic search intent analysis across your keywords. You might like: Using REGEXMATCH to determine search intent
#WORD COUNTER GOOGLE SHEETS HOW TO#
How to make REGEXMATCH match upper and lower cases: If you change some of the keywords to upper-case “Crust”, the same function can’t find them since they don’t match the regular expression.įortunately, the regular expressions provide endless possibilities to customize your searches.
Important to note, that this regex matching is case-sensitive, so it distinguishes upper-case and lower-case letters. With a simple REGEXMATCH function, you can write the following logical test that returns TRUE or FALSE:ĭragging the formula down will look for TRUE/FALSE in the whole range: You may want to know whether your most popular keywords contain a specific word such as the word “mexican”. REGEXMATCH is very useful for combing through large keyword research docs.įor example, it can be useful if you want to check whether a text contains a certain word.
How To Use The REGEXMATCH in Google Sheets Doing some simple search intent analysis.When to use REGEXMATCH for marketing stuff? The input argument is the string to be matched to the regular expression and the second argument, regular_expression, is the regular expression itself. The REGEXMATCH function has the following syntax: It’s used to compare an input string to a regular expression and return whether that piece of text matches the regular expression. The REGEXMATCH is one of the three regex functions (REGEXREPLACE + REGEXEXTRACT being the others) in Google Sheets. In this post, we’ll be checking out REGEXMATCH. The 3 main Regex formulas you can use on Google Sheets are: Regex is a matching expression tool returning specific values (like true or false), whether it finds the expression or not. What if I told you there was a way to speed up your data wrangling? Instead of sorting through data manually, wouldn’t it be good if you could use a formula to categories stuff? Working with big data sets in spreadsheets is an everyday part of SEO.
How To Use The REGEXMATCH in Google Sheets.
0 kommentar(er)
