Questions tagged [regexextract]
For questions about a spreadsheet function that allows selection from a string on the basis of a regular expression.
13
questions with no upvoted or accepted answers
1
vote
0
answers
55
views
Why 2 columns of the same value give different total?
Sample Data in Result Sheet
I have a formula in A2 that extracts data & splits it into unit & product (A & B).
I used the SUMIF formula to give the the total of each separate set of ...
- 345
1
vote
1
answer
268
views
Using REGEXEXTRACT to retrieve specific content from two separate rows in the same column
I Included a Google Sheets link
=REGEXEXTRACT(A2:A3, "19..")
To me, it would seem as if this would check both cells for any date starting with 19 and extract that into the cell
But, it ...
- 11
1
vote
1
answer
150
views
Can I populate Google Sheets cells adjacent to a target cell?
I have a maintenance tracker in Google Sheets for lighting fixtures. One column is a type of fixture "B", the column adjacent is the problem "C". I'd like to find specific fixtures by name and copy ...
0
votes
1
answer
20
views
How do I use REGEXTRACT to return grouped numbers from a string where the number of groups varies?
In Google Sheets, I'm trying to return numbers from within a text string.
The numbers are values of the property named either item_id or item_ids.
I've tried the REGEXTRACT function but I'm struggling....
0
votes
0
answers
97
views
IMPORTRANGE contains specific columns with multiple answers
Example, one person can enter 5 events with several options for participating (both days or Sunday only or 1st go....) how do I get master1 sheet to only show contestants on Saturday and master2 only ...
0
votes
1
answer
389
views
Extract Data from 2 columns if it matches condition
This is how my main data sheet looks like
And for any item that has customization, for e.g. - ORGANIC, I want to extract/copy just those data, the meal name & total units to another sheet.
And ...
- 345
0
votes
1
answer
229
views
I want to get values from multiple URL's in Google Spreadsheet. IMPORTDATA doesnt work
I have 9000 lines with URL's in my Google Sheet.
Example: https://steamcommunity.com/auction/ajaxgetgoovalueforitemtype/?appid=233860&item_type=10).
Every URL returns JSON like this:
{
"success": ...
- 1
0
votes
1
answer
49
views
How to partial extract from 3 columns with multiple levels of rules?
The formula someone on this forum provided worked well, but I have run into a problem, which I am struggling to get around.
Google sheets Link
The formula in H2 looks between 00 & 02 and ...
- 135
-1
votes
1
answer
990
views
How do I use non capturing groups in google sheets?
This is what I intend to do.
But a similar one doesn't work.
As with any problem I post, I still can't solve it after more than two hours of trying. :-(
https://github.com/google/re2/wiki/Syntax
- 111
-1
votes
1
answer
35
views
How can I extract specific information from the cells?
How can I extract just the: Brand, Showroom Only Product, etc.
- 1
-1
votes
1
answer
69
views
Inaccurate output when using importrange vs manual input
I have a little problem using Google Sheets. I'm using importrange to get raw data from another sheet that I don't own. This is the sample raw data, then import it my own sheet here.
Importing data ...
- 7
-1
votes
2
answers
117
views
How to move a Google Sheet from one file to another while retaining external references
Background
I usually add several sheets to a single Google sheets file. There is always a separate sheet that extracts information from the other sheets (via REGEXEXTRACT etc).
Problem
sometimes ...
- 1,179
-1
votes
1
answer
54
views
Multiplying several numbers within a text string, is this possible?
I have cell A1 which is a text string:
100 blue cars, 100 red cars, 100 yellow cars
In cell B1 I have a number which is a multiplier say 2.
Is it possible to change the numbers within cell A1 ...
