bran | Static analysis framework for EVM bytecode | Bytecode library

I have this function which takes an array, counts how often each item occurs, and returns an array of unique items, ordered by count first, then alphabetically sorted, and then alphabetically case-insensitive so that order does not change between runs.

I'm trying to make a boxplot where my MFR (manufacturers) are displayed on the x axis and the rating is on the y axis. However I want to color the different boxplots based on the mean shelf value. (Shelf is a value between 1 and 3)

I tried this code:

I have an ingredient dataset and each row is a list of ingredients that's separated by comma, for example:

Oats (24%) (Rolled, Bran), Coconut (13%) (Coconut , Preservative (220, 223)), Brown Sugar, Milk Solids, Golden Syrup (10%), Seeds (9%) (Sesame , Sunflower), Margarine (Vegetable Oil, Water, Salt, Emulsifiers (471, Soy Lecithin), Antioxidant (307)), Glucose, Milk Choc Compound (5%) (Sugar, Vegetable Oil, Milk Solids, Cocoa Powder, Emulsifiers (Soy Lecithin, 492), Natural Flavour), Natural Flavour

I want to parse the file to replace only commas within brackets with a semicolon. There can be any number of brackets and any number of commas within the brackets. The result should look like this:

Oats (24%) (Rolled;Bran), Coconut (13%) (Coconut ; Preservative (220; 223)), Brown Sugar, Milk Solids, Golden Syrup (10%), Seeds (9%) (Sesame ;Sunflower), Margarine (Vegetable Oil; Water; Salt; Emulsifiers (471; Soy Lecithin); Antioxidant (307)), Glucose, Milk Choc Compound (5%) (Sugar; Vegetable Oil; Milk Solids; Cocoa Powder; Emulsifiers (Soy Lecithin; 492); Natural Flavour), Natural Flavour

Can I get some help on regex that will solve the problem? Thank you in advance.

I have a sheet with First Name Variants on one tab and a search table called "Import" on another. I used a Query function =if(B4="","",QUERY('First Names'!B:C, "Select C where B matches '.*"&B4&".*' limit 1",0)) on the Import tab to return column C on the First Names tab by looking for a partial match in column B.

However, if I type in the name Jon, it returns Jo Video instead of John Video. It does this because of the name Jonnelle on the row of Jo video.

Another thing, if I type in the name Bran, it returns Branch Video even if the name Bran is not in the entire list. I want to return an N/A error instead.

So my question is How to structure the query formula or other formula to do the job correctly?

Here's a link to the sample sheet: https://docs.google.com/spreadsheets/d/1ymK9fdfl9Me0QU5OhM44K3RRaXnZ6rTSQXKOyAO1cFc/edit?usp=sharing

Here are some screenshots of the sheet:

First Names sheet Import tab First Names sheet First Names tab

Thank you in advance for answering! Will definitely appreciate it.

I have a Stata dataset which has six variables with consumed food ingredient codes and their weight in grams. I have another distinct dataset which has food ingredient codes and consecutive calorie per 100 g. I need to replace codes with calorie to calculate total calorie consumption.

How can I do that? (by replacing or generating new variable)

My first (master) dataset is

I have a table like below which has names and ids.

And there is another table like below

I need a query which will give brothers' name for stark family in one row with separate by comma

Thank you for help

I am trying to loop the object output with event, but for some reason I am missing something. codepen

After the text changes color on click event, I am trying to change the text color again automatically (without clicking) after a set time like one second. This is what I have so far.

So I have file1.txt: