Questions tagged [regexextract]
For questions about a spreadsheet function that allows selection from a string on the basis of a regular expression.
6
questions
5
votes
1
answer
6k
views
How to apply a relative reference in conditional formatting formula?
I have a whole bunch of cells (28 so far) that need conditional formatting.
Here is what the data looks like:
I want the colours in the top "Last Period" metric cells to vary depending on the values ...
- 648
3
votes
2
answers
2k
views
How can social hashtags be extracted from a cell?
Example:
A2 -> What a beautiful day! #sunday #summer
B3 -> #news Stay tuned for our next contest! #something
Desired output on B2 ->#sunday #summer
Desired output on B3 ->#news #...
- 51
1
vote
1
answer
349
views
Pretty print google sheet formula?
Finding answers on Web Apps SE or Reddit is wonderful, but if you don't understand them you can't modify them.
I recently came across the following as part of an answer:
={"Corrected List 2";...
3
votes
1
answer
2k
views
How to categorize data in Google Spreadsheet using regular expressions
I'm trying to categorize some data in a Google spreadsheet.
I have "phrases to screen" in column A, TAB "Phrases". For example "blueish house"
I have "words" in column A, TAB "Words". For example, "...
- 33
3
votes
1
answer
247
views
How to modify REGEXEXTRACT to import total hours played on Steam
My problem is similar as the one answered here: How to create an auto updating Google spreadsheet with information from Steam?
Only I need to modify the REGEXEXTRACTs to find total hours played ...
- 31
0
votes
1
answer
169
views
How would you find and extract the 2nd ocurrence and extract only the number that is in between =value"123456789"?
Any expert on Google Sheets Regular expressions? I am trying to extract the numbers that exist in the second occurrence of this pattern value="400" from the HTML text that I am sharing in ...
- 39