dale | programming language that uses S-expressions for syntax | Compiler library

Truth is, working with names can be subject to various edge-cases that will prove a working solution wrong at some point. But for those samples shown I'd use FILTERXML() to "split" these input strings on the spaces and use xpath expressions to filter out those substrings:

Formula in B1:

Try and set the encoding to UTF-8

For example:

file = open(filename, encoding="utf8")

For reference check this post:

UnicodeDecodeError: 'charmap' codec can't decode byte X in position Y: character maps to

First, i have added classes where you have used id's, because id's can't be duplicated, and i have added one small change to your function call, adding current button element as argument.

So, your HTML should look like this now:

You have to apply `RIGHT function with 36 for uniqueidentifier'. As right side, it is uniqueidentifier, in the left side also, you need to cast the datatype as uniqueidentifier to make the comparison working.

You don't need to cast varchar value to uniqueidentifier, as datatype precedence takes care of implicit conversion to higher datatype. Reference datatype precedence

You can use reduce to build one string of the whole dictionary

Firstly, this assumes that your JSON is actually valid. None of your elements (id and name) are quoted, so the JSON is actually invalid. Also I assume your expected results are wrong, as Charlie is give the age of 20, but that age belongs to someone with an id with the value 3, and Charlie's has an id of 5.

Anyway, we can can achieve this with a subquery:

What you are trying to do isn't possible in Ruby, because Ruby does not have "pass by reference" parameters, but always passes by pointer. This means when you make an assignment in a method to a parameter then this doesn't change the value of the variable on the outside:

When you iterate over your list by for item in transactions_clean: you get items for each list, so indexing them like item[1] would just give you string characters. If the order is always like customer -> sale -> thread_sold, you can do something like this:

You are confusing yourself. You have your solution in edges. There isn't a reason to read the data a second time. For example, you can simply output sorted/unique elements of edges, e.g. the modifications to your code are: