Questions tagged [regex]
regex stands for "regular expressions". They are used to define a string search pattern that could be used in some web applications like Google editors to do input validation, search and replace among other similar tasks.
177 questions
2 votes
1 answer
63 views
Parse strings like "5 days 12 hours 49 mins" as a duration
My data durations formatted like 5 days 12 hours 49 mins. What is the easiest way to transform these strings into numeric durations, and extract the number of days, hours and minutes? Bear in mind ...
- 125
1 vote
1 answer
73 views
How do I set up conditional formatting for values that contain text from a cell in another tab?
From similar problems I found online, I've tried a number of regexmatch and combined it with indirect but nothing seems to work. Here's a sample of my sheet: https://docs.google.com/spreadsheets/d/...
2 votes
1 answer
160 views
Check whether a value appears in one of five columns in another sheet and return a specified value depending on which one it's in
I'm really tired and can't remember how to make this work so would appreciate any pointers on where I'm going wrong. I'm trying to do the following: Get cell K2 to provide a specified text value ...
- 31
2 votes
2 answers
2k views
Google Sheets Conditional format when cell contains any word from another cell (partial text match)
I am currently using =regexmatch(A1,"(?i)N02|N22|J25") in column A to highlight the cells that contain these terms. But I don't want to hardcode it as the search terms keep changing. The ...
- 383
0 votes
3 answers
208 views
Filter formula: Exclude data without a timestamp
=sort( filter( { Bryson!A4:S502; David!A4:S502; Justin!A4:S502; Michael!A4:S502; Manny!A4:S502; ScottC!A4:S502; ScottD!A4:S502; Zhenqian!A4:S502; Visitors!A4:S502 }, regexmatch({ Bryson!Q4:...
4 votes
1 answer
1k views
Find the words after the last symbol
Any expert on Google Sheets Regular expressions? I am trying to extract all the text after the last two dots symbol found : Example on the text= Roger : Blue Large : pack : high brand the word that I ...
- 49
2 votes
1 answer
178 views
Using Google Sheets to bulk collect the number of Google Search results count for given keywords
I need to bulk check the number of Google Search results count for given keywords by using Google Sheets For example, ocean is About 2,960,000,000 results
2 votes
1 answer
544 views
Using wildcards in gmail (trying to auto block spam emails that have no unsubscribe button)
About a year ago, I started getting emails form very random email addresses that are just extremely obvious to be spam. However, just blocking one single user account doesn't do the trick because the ...
- 141