lopez | Crawling and scraping the Web for fun and profit | Scraper library

I would like to segment (isolate) the rod-like structures shown in this image:

The best I've managed to do is this

Hello people from stackeoverflow, I have the following table:

Input

!

I need to group by name, lastname and if one or more status of a person are 'sending' then the new_col will be 'not finished', if all status of a person are 'sended' then new_col will be 'finished'.

Expected output

I try grouping but I'm stuck figuring this out.

Thanks in advance.

Most formulas I already checked are about finding if a specific cell exists in a range. I am trying to check the opposite, if values from a specific range exist as substring in a specific cell.

Example, my range A1:A10 is:

i am attempting to find the true file size as suggested by response at previous inquiry.

The response says to use GET projects/:project_id/folders/:folder_id/contents to find the hub_id and file_id of files on the BIM 360 docs hub.

Whevener I use the bucket id as retrieved from GET projects/:project_id/folders/:folder_id/contents the message is returned "Bucket not found"

How to find the bucket_id of files on BIM 360 docs?

For example, this is how my file information reads at GET https://developer.api.autodesk.com/data/v1/projects/:project_id/folders/:folder_id/contents

I have a dataframe in R that contains people data. First part of a string is a full name. Every so often I encounter a nickname in brackets. There could be other data enclosed in brackets that I do not want to delete. Here is an example of a kind of data I am working with:

I need to sort through the JSON and for all the verified users add a option to the attribute which has a id of verified-users-list. The issue is that I am trying to append the results of the verified users to HTML function getVerifiedUsers(id, url) { var ourRequest = new XMLHttpRequest(); ourRequest.open('GET', url); ourRequest.onload = function() { var ourData = JSON.parse(ourRequest.responseText); let test = verified(ourData) //console.log(test); $(id).append(`${test.name}`); } ourRequest.send(); } function verified(data) { var user = {}; var j = 0; for (let i = 0; i < data.length; i++) { if (data[i].verified == true) { user[j] = data[i]; j++; } } return user } getVerifiedUsers("#verified-users-list", "http://localhost:3000/user"); AJAX response: [{ "id": 0, "name": "Yan Li", "verified": true }, { "id": 1, "name": "Anna Lopez" }, { "id": 2, "name": "Bobby Patel", "verified": true }]

I’m looking to Split a text according to each interlocutor.

The original text has this form:

this is a speech text. FIRST PERSON: hi all, thank you for coming. SECOND PERSON: thank you for inviting us. TERCER PERSONA QUE SE LLAMA PEDRO: soy de acuerdo. CUARTA PERSONA (JOHN): Hi. How are you

I’m searching for a final result like this:

first column: FIRST PERSON |SECOND PERSON | TERCER PERSONA QUE SE LLAMA PEDRO | CUARTA PERSONA (JOHN)

second column: hi all, thank you for coming | thank you for inviting us | soy de acuerdo | Hi. How are you

The final result can also be in other format or reshaped.

The Pattern to split is one or more Upper Word and a ":", but one difficulty is that the pattern in capital letters can have optional characters like: ():,;

In fact the original text that I am searching to split is this one: https://lopezobrador.org.mx/2021/01/14/version-estenografica-de-la-conferencia-de-prensa-matutina-del-presidente-andres-manuel-lopez-obrador-458/

I have tried different things using stringr rebus and qdap. First trying this pattern:

I have array structure as shown in below

as it says in the title my xml does not read my xslt, I want to make a list taking the "first name" and "last name" but it doesn't work for me, I don't know if I'm making a mistake when putting the name or maybe I'm not doing well, saying that everything is stored in the same folder so there should be no problem but there is. I am attaching my xml and xslt to see if I am getting something wrong:

xml name "comunidad":