Your use of Stack Overflow’s Products and Services, including the Stack Overflow Network, is subject to these policies and terms.
Join us in building a kind, collaborative learning community via our updated
Code of Conduct.
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.
I have data in this format:
and I need it to be reformatted into this:
Basically, each row in the initial format is composed of 4 concatenated sections of equal lengths: Part(s), Product(s), Quant(s)...
I've got a weird question about Google Sheets.
First, here's what I've got so far, but it returns an error "Function REGEXEXTRACT parameter 2 value "My Text here" is not a valid regular expression."
Let's say that I have a big Google spreadsheet that multiple users have access to, and I'm not able to control which users have access to it. I have a concern for trolls.
How would I prevent people ...
Using Google sheets, here's what I'm trying to accomplish:
I have data that comes in like this:
AO CPC ALL GAM
AO CPC ALL PA
I'm using a free text field in a Google Form. Users should be able to enter the name of a product followed by its price, then start a next line for the next product. To validate their entry I want to ...
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 ...
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 ...
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:
If Gmail supported regular expressions it would be ...
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|...
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 ...
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 ...