Can I filter a list of email addresses that contain words from another list in Google Sheets?

I have a list of thousands of email addresses and am trying to filter out those that contain certain words. I have the list of words in the same table and am currently filtering the email addresses by Condition> Text Contains>. Then I type every word manually.
But my word list is in the hundreds.
Is there a way to filter using the custom formula: my list of words& # 39 ;?

List – SharePoint FilterValue in URL with hyphens, periods, parens etc

How can I mask / encode certain characters in a FilterValue part of the SharePoint query string? I can use encodeuricomponent to get most of them, but SharePoint still needs hyphens, parens, periods, etc. for the filter to work. For example a FilterValue from <99-22.364(a) Test>, How can I encode / mask this value?

swift – Manage last list of objects of type user and employee

So I have a view that shows the last 5 employees and 5 customers for a restaurant app. I save this in the user profile.

I also manage the currently selected object.

Here is my class.

//This class is used for saving the user object and fetching the user object from user default
// user obejct can be Staff User or Customer object

enum RecentStaffErros : Error {
    case userObjectAddUpdateFailed

protocol RecentListManagable:FireCodable {
    var firstName: String? { get set }
    var lastName: String? { get set }

class RecentUserDataManager {

    var selectedData:T? = nil
    private let recentLimit = 5
    private(set) var recentUsers:(T) = ()
    private var userDefaultKey:UserDefaults.RecentUsersList.ArrayDefaultKey

    var recentUserDidChanged:(((T)) -> Void)?

    var isDataAvailable:Bool {
        return recentUsers.isEmpty

    init(userDefaultKey:UserDefaults.RecentUsersList.ArrayDefaultKey) {
        self.userDefaultKey = userDefaultKey

    private func fetchLastFiveStaffUsersFromUserDefault() {
        let staffUsers = UserDefaults.RecentUsersList.array(forKey: userDefaultKey) as? ((String:Any))
        self.recentUsers =   staffUsers?.map({ (object) -> T?  in
            if let staffData = {
                return try? JSONDecoder().decode(T.self, from: staffData)
            return nil
        }).compactMap{$0} ?? ()


    private func saveLastFiveCustomerToUserDefault() {
        let arrayOfDictionary = {$0.values}.compactMap{$0}
        UserDefaults.RecentUsersList.set(arrayOfDictionary, forKey: userDefaultKey)

    func addOrUpdateStaffUserIfRequired(_ user:T) throws  {
        guard  let data = user.values else {
            throw RecentStaffErros.userObjectAddUpdateFailed
        //we found the data remove from that index and append to bottom
        if let index =  recentUsers.firstIndex(where: {$ ==}) {
            self.recentUsers.remove(at: index)
            //append new object
        self.recentUsers.insert(user, at: 0)

        if self.recentUsers.count > 5 {
            //keep only 5 users
            self.recentUsers = Array(self.recentUsers.prefix(recentLimit))



    func switchCurrentSelectedUser(_ user:T) {
        self.selectedData = user


In my view controller, where I manage the list

 private var recentStaffUsers:RecentUserDataManager = RecentUserDataManager(userDefaultKey: .arrayStaffUsers)

 private var recentCustomerUsers:RecentUserDataManager = RecentUserDataManager(userDefaultKey: .arrayCustomerUser)

 private func setupForCustomer() {
        createButtonsForCustomer() //create 5 buttons 
        recentCustomerUsers.recentUserDidChanged = {(weak self) _ in
            DispatchQueue.main.async {
                //When New customer added or removed update Buttons

Do you see any improvements or problems in my code?
I should think to redesign RecentUserDataManager deeper as separate logic

Formulas – Google Sheets To-Do List: INDEX / MATCH and questions about cell updates

I am currently working on a to-do list dashboard for my household chores ( and have some questions.

I am trying to retrieve daily tasks from a raw data table using an index / match array formula, but am having trouble browsing the table for situations where there may be multiple tasks in a day and posting them to the task list. I've tried a few setups of array formulas (both parentheses and CSE) and the formula still stops after finding the first instance of the date.

A second question is that I would also like to mark every task as done in the dashboard, but for this to work I would have to change a cell in the "Raw data" table as far as I can tell. I can't do this with formulas and tried to write a simple script, but I don't think it has permission to write to a separate cell. Is that correct or is there another / better way to do this? Thank you for reading!

Retrieve all items from a SharePoint list and insert each field into an object

I'm trying to get all the items in a list from a SharePoint site. The fields have the headings "Review Level Title", "Reviewer IDs" and "Review Level Priority". I try to get the information from all three fields separately, paste it into the object I created, and then return the list of all the objects that I created for each SharePoint item.

I have researched a lot about accessing this information from the SharePoint site, but I cannot get it to work. I've created the following so far:

public List Get()
            var operationsReviewLevels = new List();

            ClientContext context = new ClientContext(ConfigurationManager.AppSettings("SharePointEngineeringChangeRequest"));
            var SPList = context.Web.Lists.GetByTitle("Review Levels");

            CamlQuery query = new CamlQuery();
            ListItemCollection entries = SPList.GetItems(query);


            foreach(ListItem currentEntry in entries)
                operationsReviewLevels.Add(new OperationsReviewLevel(currentEntry("Review Level Title").ToString(), currentEntry("Reviewer IDs").ToString(), (int)currentEntry("Review Level Priority")));

            return operationsReviewLevels;


Whenever I try this code, I get an error message:

Microsoft.SharePoint.Client.PropertyOrFieldNotInitializedException: The property or field was not initialized. It was not requested or the request was not carried out. It may have to be requested explicitly.

I can't find a solution to this error online (in my scenario) and was wondering if anyone can see what I'm doing wrong in this scenario.

Thank you all!

robotframework – What's the difference between "Should Be True $ {list} == [‘a’, ‘b’, ‘c’]"and" should be true $ list == [‘a’, ‘b’, ‘c’]"?

Consider the following code in built-in-library-tests.robot:

*** Test Cases ***
Use "Create List"
   #  The returned list can be assigned both to ${scalar} and @{list} variables
   @{list} =   Create List     a   b   c
   Should Be True      ${list} == ('a', 'b', 'c')    # (1)
   Should Be True      $list == ('a', 'b', 'c')      # (2)

For me, (1) and (2) have to differ in their execution, even if they both exist.

In 1)$ {list} is replaced by a string representation of the @list (i.e. (& # 39; a & # 39 ;, & # 39; b & # 39 ;, & # 39; c & # 39;)), which results in the expression as a string:

(& # 39; a & # 39 ;, & # 39; b & # 39 ;, & # 39; c & # 39;) == (& # 39; a & # 39 ;, & # 39; b & # 39 ;, & # 39; C # 39)

(1) is like running eval ("(& # 39; a & # 39 ;, & # 39; b & # 39 ;, & # 39; c & # 39;) == (& # 39; a & # 39; , & # 39; b & # 39 ;, & # 39; c & # 39;) ") on a Python console.

In 2), the inner steps are a little different (I assume): first the $list In the evaluation, the namespace refers to Robot's @ {list} object. This is the list object. Then another list object is instantiated in the evaluation namespace (somehow?) And these lists are compared to be the same.

Can you correct my understanding

c – Add or delete items from a linked list

I am relatively new to programming since I just started at university. My job is to develop a program (using a function and a linked list of pointers with integer elements) that does the following:

  • The function visits every element from the beginning. if the current element is plus one <= to the following element (eg. if the first one is i and the second one is j, j>= i + 1) you must complete the list by adding all values ​​between i and j-1.

  • If the current element is followed by an element <=, it is removed from the list and added to an array declared in the formal parameters. You must also enter a counter for the deleted elements in the formal parameters.

I have absolutely no idea what I'm doing wrong. Sorry if I make grammatical mistakes, English is not my mother tongue.


struct list {
    int value;
    struct list * next_ptr; };

void pre_insert(struct list ** ptrptr, int value) {

    struct list * tmp_ptr;

    tmp_ptr = *ptrptr;
    *ptrptr = (struct list*)malloc(sizeof(struct list));
    (*ptrptr)->value = value;
    (*ptrptr)->next_ptr = tmp_ptr;

int complete_list_array(struct list * ptr, int * V, int * count) {

    struct list * succ_ptr;
    int i, k = 0;

    while (ptr != NULL) {  
        if (ptr->next_ptr != NULL) { 
            succ_ptr = ptr->next_ptr; 
            if (ptr->value + 1 <= succ_ptr->value) { 
                for(i = 1; ptr->value + i <= succ_ptr->value; i++) { //
                    succ_ptr = succ_ptr->next_ptr;
                    ptr = ptr->next_ptr;
                    pre_insert(&ptr, ptr->value+ i); } 
                 ptr = ptr->next_ptr; }
            else if (ptr->value >= succ_ptr->value) { 
            ptr->next_ptr = succ_ptr->next_ptr; 
            V(k) = succ_ptr->value;
            ptr = ptr->next_ptr; }  } }

    return (*count);}

struct list * create_list(int N) {
    struct list * first_ptr, * ptr;
    int i;

    if(N == 0) {
        first_ptr = NULL;
    else {

        first_ptr = (struct list *)malloc(sizeof(struct list)); 
        printf("Insert the first value:n");
        scanf("%d", &first_ptr->value);
        ptr = first_ptr; 

        for(i = 2; i <= N; i++) {
            ptr->next_ptr = (struct list *)malloc(sizeof(struct list));
            ptr = ptr->next_ptr;
            printf("Insert element number %d:n", i);
            scanf("%d", &ptr->value); }

        ptr->next_ptr = NULL; }


void visit(struct list * ptr) {
    int i = 1;
    while(ptr != NULL) {
        printf("The element number %d in the list has value %d.n", i, ptr->value);
        ptr = ptr->next_ptr;
    i++;} }

int main() {

    struct list * first_ptr;
    int N;

    printf("Insert the number N of elements in the list.n");
    scanf("%d", &N);

    first_ptr = create_list(N);

    printf("Elements of the list.n");

    int * V, count = 0;
    V = (int *)malloc(sizeof(int)* N);

    count = complete_list_array(first_ptr, V, &count);

    printf("count = %d", count);