I created the following code to extract numerical information from a user-provided string, which specifies the level or floor in a building. The goal is to accurately extract the numerical value from the input. However, the current implementation does not…
I'm working on an express.js project, using Sequelize as the orm, and postgres as the engine. I'm working on improving the performance of a slow select query that does many things, and one of them is comparing the acronym of…
I've created a regex pattern to match sequences of digits that can be ascending or descending, like 12345, 123, 321, 6789, 7654, etc. However, I believe this approach may not be the most efficient or professional way to achieve this…
So it is possible to fall-through the case to another case: switch(variable) { case 1: // do something 1 case 2: // do something 2 break; case 3: // do something 3 break; } But what if we would want…
Using PostgreSQL, how can I replace all forward slashes by a hyphen after 5 occurrences of a forward slash like so: https://this/is/a/very/long/url to this : https://this/is/a/very-long-url
I encountered a TypeError with data received from an API. To simulate the issue clearly, I have provided a code example below: //This is mock data to simulate the API. //The length of the array or the keys is not…
I have a sequence of folders containing mp4 files (one mp4 in one folder). Folders are numbered sequentially like this example: .. .. 18. Lesson 18 - Sketching a design to cut out 19. Lesson 19 - How to create…
I want to improve performance of my queries using GIN index on jsonb column for pattern matching For example, I have a table defined as: CREATE TABLE my_table ( uuid text, doc jsonb ); In every row of table doc…
I am new to Javascript and I'm currently learning how to print messages in consoles with the help of for and while loops. I am just trying to print patterns starting with a simple triangle for which I wrote the…
Since i try to used this regular expression /names+([A-Za-z0-9]+(?:-[A-Za-z0-9]+)*[A-Za-z0-9])(?!S)/g; my input that i want is for example: name test name test-name name test-name-2 but when i try to check this input it's also allowed name test-name anytext what i want…