spray | scala libraries for building and consuming RESTful web | Reactive Programming library

I have supplier name together with product name in one cell as a string.
Each cell has a word that's all uppercase (sometimes with a digit or a number).

Data I need to extract 3LAB Anti - Aging Oil 30ml 3LAB 3LAB Aqua BB SPF40 #1 14g 3LAB 3LAB SAMPLE Perfect Neck Cream 6ml 3LAB 3LAB SAMPLE Super h" Serum Super Age-Defying Serum 3ml" 3LAB 3LAB TTTTT Perfect Mask Lifting Firming Brightening 28ml 3LAB 3LAB The Cream 50ml 3LAB 3LAB The Serum 40ml 3LAB 4711 Acqua Colonia Intense Floral Fields Of Ireland EDC spray 170ml EDC 4711 Acqua Colonia Intense Pure Brezze Of Himalaya EDC spray 50m" EDC

I need to extract only that UPPERCASE supplier name to a new cell.
I've tried to create User Defined Function like this one, but it's not working.
It's returning #NAME? error.

...

I am trying to write a script to password spray user credentials. It take a password from pass_list file and then tries all the usernames from user_list. Then it will take the next password and try all the users with it. However, this loop doesn't work the way I want it.

...

When I try to sbt build my project, the project build fails with an "extracting product structure failed" error. I am suspecting something related to the versions I am using for Alpakka and Akka.

Here is my build.sbt file:

...

I don't know what to say. Second day straight I try to get the value from JSON object juggling many Scala libraries. This one is Akka with spray. I try to save where on earth id to variable and return it from function/method. I does not matter for me if it will be Future or not, but I'm stuck at this statement int = for {lel <- ss} yield lel. Whatever I try, I always get the initial value of int wherever it is a class, case class, Future[Int] or Int. Please advice.

...

I use spray json in my application and for models I need to write JsonProtocol companions.

Because in the service I have more models, I have two options to use these JsonProtocols:

a) make TableauErrorResponseJsonProtocol a trait and extend it by my service

b) make TableauErrorResponseJsonProtocol an object and import it where I need in my service (as in picture)

I try to avoid using option a) because I already have some extends for my service, so I don't want to use with x, with y, with z, ....

But, for option b), when I want to rearrange the code (CTRL + ALT + SHIFT + L), IntelliJ will remove all these imports, because are "unused". In reallity, these both are used by the next line (response.data.parseJson.convertTo[MyClass]).

How I can avoid it? thanks

...

I am trying to write code for the following: The idea is to have a storage/inventory dictionary and then have the key values be reduced by certain household tasks. E.g. cleaning, cooking etc.

This would be the storage dictionary:

...

I have a 3 deep array. Currently, the code will isolate a record based on one field ($profcode) and show the heading. Eventually, I am going to build a table showing the information from all the other fields. The code so far is using in_array and a function that accepts $profcode. I am unsure if (and how) I need to use array_keys() to do the next part when I retrieve the "Skills" field. I tried:

...

I have a database of items, now I need to update the pictures in 10,000 records in the database, I make an API request, I receive an answer, but I just cannot process the answer correctly.

I received result:

...

I am working on a webapp that exclusively uses Tailwind for the frontend, and I have constructed a simple sidebar for it like so:

...