timmy | A time management tool

I am learning OOP at the moment with python. I wrote the following code.

I have got two collections, chapters and courses with one-to-one association,

I am working with Deno and Typescript; say I have a main class called 'A' in this example. And I wanted some other classes with unique methods to extend this class 'A'

So like:

im now working on sending a notification when triggered that sends an embedded message to discord from google scripts.

I've gone through multiple resources however cannot find one that works. I can get a simple message sent across using webhooks however anytime attempt to insert an embed it doesnt seem to send, however dont get any errors appearing.

Is there a way to pause code execution in JS? I'm trying to create a browser based terminal, and I'm having trouble creating a user input type functionality.

Essentially I want to have a parameter called currentCommand which initializes in a false state and a function which waits for the currentCommand variable to change before completing like:

I've been trying to figure this out for about a year now and I'm really burnt out on it so please excuse me if this explanation is a bit rough.

I cannot include job data, but it would be accurate to imagine 2 csv files both with the first column populated with values (Serial numbers/phone numbers/names, doesn't matter - just values). Between both csv files, some values would match while other values would only be contained in one or the other (Timmy is in both files and is a match, Robert is only in file 1 and does not match any name in file 2).

I can successfully output a csv value ONCE that exists in the both csv files (I.e. both files contain "Value78", output file will contain "Value78" only once). When I try to tack on an else statement to my if condition, to handle non-matching items, the program will output 1 entry for every item it does not match with (makes 100% sense, matches happen once but every other comparison result besides the match is a non-match). I cannot envision a structure or method to hold the fields that don't match back so that they can be output once and not overrun my terminal or output file.

My goal is to output two csv files, matches and non-matches, with the non-matches having only one entry per value.

Anyways, onto the code:

I have a table in SQL server. I am trying to append a spark dataframe from databricks to the SQL table. I am able to append the new rows but the problem is that it appends randomly to the SQL table. I want to append the new rows to the end of the SQL table. How do I do that?

SQL table

I have a working chart.js on https://www.flottefeger.ch/charts.html I am trying to add an on click event to my Line chart using Chart.js. two values I can alert to pop up. But I need one more parameter. The ones which are in the label in the datasets.

It looks like that:

But now my question, how can I get which graph I have clicked? I mean the value in the label?

In my example, it could be Timmy or Siri

Using an MS Excel formula, I would like to find the Position(s)/Location of specific words found within a String of text located in a Range/Column of cells.

I'm using a formula that only identifies and finds the position(s) of a keyword by a single cell versus a column. I'm not able to repeat this action by looking throughout the column cells, using my numeric helper column (Cell D2:D12 "Occurrence") which provides the occurrence of the next position to be found.

Helper columns are welcomed if necessary to achieve the desired results.

The cells highlighted in "Red" is what I'm looking for as the final output results.

See below for formulas used for Column C and D. Text string is located in Column A2:A12.

COLUMN A DATA TEXT
Dolly would not count her eggs but Count her apples
Tony drove a pickup truck to work
Over many nights he could not sleep
Only this and nothing more
She went by to pickup her son
To many times he would count over
They went shopping for Christmas
You can count him to pickup someone
They count so much they would sleep in his pickup
Nobody would play with Timmy
Trying to find the position location of each word

COLUMN B Keyword List
Toe
Shoe
Count
Pumpkin
Pickup
Randy
Sally
Sleep
Jonathan

C2: =SUMPRODUCT((LEN($A$2:$A$12)-LEN(SUBSTITUTE((UPPER($A$2:$A$12)),UPPER(B2),"")))/LEN(B2))
D2&E2: =FILTER(B2:C10,C2:C10>0)
F2: =IF(E2="","",REPT(D2&"^",E2))
G2: =TEXTJOIN("",TRUE,F2:F4)
H2: =TRIM(MID(SUBSTITUTE($G$2,"^",REPT(" ",LEN($G$2))),(COUNTIF($H$1:H1,"<>&""")-1)*LEN($G$2)+1,LEN($G$2)))
I2: =IF(H2="","",IF(COUNTIF($H$2:H2,H2)>1,SUM(I1+1),1))