irma | Digital organisms ecology system experiment

Example Table, Turn this

and turn this into

Is this possible to do in MS Access?

I'm using Material UI V4 Data Grid component in a React Js app.

The Data Grid component has required rows (list type) and columns (list type) props.

Here is a sample of a row item:

enter image description here'

I'm having problems with the return of this array, when I call it integer no problem, I get the return normally, but when I call by index, for example 1 , it would have to return 28 obj, but it's only returning by renaming 5 obj, and I can't find the reason why it's just returning 5''

I have an Excel sheet with a lot of different entries (expenses) that I want to classify. To do that, I created another sheet with different entry categories such as groceries, night out etc., and I put each in a column.

So this is my expenses sheet:

And this would be the categories sheet:

What I want to do is to have the Category defined on the categories sheet (Groceries and Night Out) on the 3rd column of the Expenses sheet. So what is in the categories sheet would be a substring of the text on the description column of the expenses sheet. So if, for example, the description has "Foetex" in it, then the Category should be Groceries.

I have tried Match, countif etc., but to no avail.

Does anyone know a way out of this?

I am trying to sort this file that has this information below

For example, when I open a topic, it would open in the same html page, not redirect to another address: http://web.archive.org/web/20090409012115/http://www.europeangoldfinch.net/home.htm#

I want to make it exactly like this (clicking on a topic). I downloaded the source files from web archive, but when I click on topic nothing opens up even though the topic text is in that html code.

This is exactly what I want to do: https://errorsea.com/how-to-change-text-onclick-event-javascript/#Syntax

EDIT: Thanks everyone for the help, I figured it out, I downloaded a website from web.archive.org, and it didn't work well, but I managed to get it working with the javascript included with the website.

Code:

I am having a problem trying to target an embedded table to collect a second set of links. It is an embarrassingly simple task.

The website: https://irma.nps.gov/DataStore/Reference/Profile/2233469 while they have an API for other products these data are not included... (I have a key - which is appended to the end of the URL- if needed, but it doesn't seem to affect this type of page).

What I am trying to do is copy all of the links which are contained in the table. Or downloading the contents of the entire table and converting it to a dataframe in R (I have achieved this with simpler tables). I should not have difficulties with that part! Although, I also believed I would be able to crack this table pretty easily...

I have followed a few different guides and questions to try and approach this problem, but I keep hitting a wall. I have been hoping to accomplish this with rvest/xml2/httr/jsonlite suite of packages, and am still not convinced I need RSelenium for this.

I have the following data:

I have a DT names_nightlight has the standard region names as shown below. The other DT disasters, where one column Location, has standard and non-standard region names as well as city/municipality names. I want to replace the non-standard region names in disasters$Location with the standard region names from names_nightlight$region.

names_nightlight: