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.

learn more… | top users | synonyms

43
votes
8answers
47k views

Is there a way to search in Google using regular expressions (regex)?

It would be very useful if Google provided a regular expression search. Is there a way to do this? (OBS: I am not talking about false regular expressions like site:, filetype:, AND, OR or "Text". I ...
15
votes
6answers
3k views

Online regex preview tool [closed]

Is there any good regex webapps out there? I'd like to be able to set which type of regex syntax is used, enter some text and a regex and get matches highlighted. Preferably with different colors so ...
8
votes
2answers
2k views

Is there a way to automatically extract (e.g. regex) information (e.g. prices) from emails (e.g. on Gmail)?

Every month I get an email from my mobile carrier which tells me how much money my contract has cost me the last month, and I'd like to be able to form that into an iOS notification with IFTTT. The ...
7
votes
3answers
2k views

Which formula extracts the domain name from an email address (bob@example.com -> example.com)?

Which Google Spreadsheets formula do I use to get the domain part from an email address? Example: bob@example.com → example.com
6
votes
1answer
595 views

Google spreadsheet query language, match using regex?

I have a query formula that looks into a table and pulls names for example: A B 1 john, andrew blah 2 drew, mike blah I want it to show me all of the rows that ...
6
votes
2answers
478 views

Is it possible to search MediaWiki sites using regular expressions?

I'd like to search for phrases using regular expressions on sites such as Wikipedia and Wikimedia Commons. Is it possible to do this? Example regex search query: (facebook|google) (corporate history|...
4
votes
1answer
799 views

Case insensitive character string filter for multiple individual columns (dynamic input for each)

I'm looking for an efficient way to filter a data set by multiple individual, case insensitive character strings for multiple columns in a Google docs spreadsheet. I can already achieve this by ...
4
votes
1answer
115 views

What tools exist that can do string matching (ex. regex) websearches? [closed]

Is there any web search tool that can do the following: Perform a web search where one of the keywords is a string pattern, such as ####suffix, and will match the best result that matches a string ...
3
votes
2answers
2k views

Google Spreadsheets Query( “where a matches '/[A-Z+]/' ”) condition

According to Google Query documentation: matches - A (preg) regular expression match. haystack matches needle is true if the regular expression in needle matches haystack. Examples: where ...
3
votes
1answer
41 views

Using regex in Google Sheets data validation

I'm trying to use a regex in the Google Sheets data validation in order to ban the input of special characters, so basically my allowed set should be [a-zA-Z0-9,./()]. I'm using the custom formula ...
3
votes
1answer
914 views

How can I search Gmail for a Windows activation key?

Somewhere lost in my Gmail is a Windows key. It's by itself in an email but I cannot find it. It's formatted like so: XXXXX-XXXXX-XXXXX-XXXXX-XXXXX If Gmail supported regular expressions it would ...
3
votes
2answers
594 views

Google Search with Regular Expressions [duplicate]

Is it possible to use regular expressions or very simple regular expressions in google search? Like search the term "goog?e", where the ? indicates a character or a number.
3
votes
1answer
142 views

Count Occurence of a Regex Search Term

Using CTRL+F indicates the number of occurrences of a search term. However, when using regex (via Find and Replace) there's no indication of count. Does anyone know how to find the number of ...
3
votes
1answer
34 views

Using regexreplace to surround numbers by parentheses

The data I'm starting with: 1 Hello 2 Just another 22 line 300 Yeah, the first step is to admit you need help I want the "finished" version to look like: (1) Hello (2) Just another (22)...
3
votes
1answer
40 views

Which regular expression flavour is used by the MediaWiki search and replace dialog?

I recently discovered this search and replace dialog in MediaWiki and have been using it more and more: But I can't seem to find the documentation on it. On the MediaWiki website I always find info ...
2
votes
2answers
4k views

Is there a way to search and replace a regular expression in Google Docs spreadsheets?

The problem is that I entered a lot of formulas like =round(x+y) into a Google Docs spreadsheet. Now I need them exported to MS Excel and the latter only accepts =round(x+y,0) as a valid format. ...
2
votes
1answer
85 views

How to sort by date with Google Spreadsheet?

Consider the following text in a single column in a spreadsheet: AAPL 2015 Dec 18 C @ 185.000 AAPL 2016 Mar 18 C @ 160.000 ... How to sort by date? I tried extracting the date using regex, but it ...
2
votes
0answers
838 views

How to write a clean gmail filter for SVN commits?

I have a dozen or so SVN projects that generate a few dozen email messages every day, each with subject line like this "[SVN projectname] in branch/trunk list of files". I want to send these email ...
2
votes
0answers
440 views

Search Engine that Doesn't Ignore Punctuation? [duplicate]

Possible Duplicate: How to search the internet for terms with special characters Is there a search engine that will not ignore punctuation marks (like $ % & ! @ #...)? I want to search ...
1
vote
2answers
369 views

Finding and removing periods in Google Spreadsheet

I'm using a Google Spreadsheet and trying to create a formula to remove a period and anything that comes before it in a cell. For example: idontwantthis.iwantthis I have used this in the past: =...
1
vote
1answer
36 views

RegexReplace produces an error

I have two sheets of data as per below: ╔═══════════╦══════╦══════════════╗ ║ SheetName ║ Cell ║ CellValue ║ ╠═══════════╬══════╬══════════════╣ ║ Sheet1 ║ B1 ║ ='sheet2'!A2 ║ ║ Sheet2 ║ ...
1
vote
2answers
1k views

REGEXEXTRACT and French accents in Google Spreadsheets

I have the following formula: =REGEXEXTRACT(source!A2,"^[\w\s\À-ÿ]+") where source!A2="Ancien Marché Saint-Jacques (1125, rue Ontario Est)" and I would like to extract Ancien Marché Saint-...
1
vote
0answers
72 views

Search a single website using regular expressions?

Is there a way to search a single web-domain using regular expressions? I've been mirroring sites with WinHTTrack and then using dtDesktopSearch but it's an incredibly inefficient process and I was ...
0
votes
1answer
1k views

RegExp for data validation

I need a help for regexp writing to validate format: any_positive_integer@any_text,any_positive_integer@any_text, ..... To be exact, "any_positive_integer@any_text" separated by commas and inside, ...
-3
votes
1answer
30 views

Use regexmatch to determine if one cell's content contains another's

I want use a cell in regexmatch as regular_expression parameter. My goal is to draw green background for A1 if B1 contains A1 inside of it. How to do this with regexmatch?