Questions tagged [regexextract]

For questions about a spreadsheet function that allows selection from a string on the basis of a regular expression.

11 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
2answers
1k views

How can I create a recursive formula in Google Sheets?

I'm making a task tracker in Google Sheets and am trying to implement subtasks. I am trying to create a formula that checks a row's "Parent Task" column, and if there is a parent task, indents the ...
0
votes
1answer
20 views

How can I extract specific information from the cells?

How can I extract just the: Brand, Showroom Only Product, etc.
0
votes
1answer
27 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 ...
0
votes
1answer
38 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
2answers
16 views

Split function doesn't get the result that I expect

A1 value is 485065/1, 2, 3 and I expect 485065 and 1, 2, 3 but it comes out 485065 and 1, 2, 2003. =split(a1,"/",false) Please help me why it does.
0
votes
0answers
61 views

Google Sheets' REGEX to group values

I need to take into account text across multiple cells using REGEXes to identify larger grouping in another cell. For example, using both a Source and Medium value to determine one larger Channel ...
0
votes
1answer
316 views

Convert Number and Text to Number

I have a spreadsheet in Google Sheets with data like this: In sheet 2, in column pricelist, the below data is there. I want the summary in sheet 1 to have the same. I have used index and match but it ...
0
votes
1answer
35 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 ...
0
votes
1answer
26 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
votes
2answers
84 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
votes
1answer
15 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 ...