Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics
Linux Systems
Linux Systems
Power Users
Power Users
Tabletop RPGs
Tabletop RPGs
tag:snake search within a tag
answers:0 unanswered questions
user:xxxx search by author id
score:0.5 posts with 0.5+ score
"snake oil" exact phrase
votes:4 posts with 4+ votes
created:<1w created < 1 week ago
post_type:xxxx type of post
Search help
Notifications
Mark all as read See all your notifications »
Q&A

General Q&A about programming, scripting, software design & architecture, process, tools, testing, and more.

37%
+1 −3
An HTML form in Hebrew is Right to Left in general but a select list inside it is Left to Right

My HTML form got dir="rtl" attribute and value and in desktop computer systems it appears Right to Left (RTL) but in my mobile device (OnePLus 6) with Android and DuckDuckGo browser, the form's HTM...

0 answers  ·  posted 1y ago by deleted user  ·  edited 1y ago by deleted user

42%
+1 −2
redirect to "main" code in Ruby using Ctrl

In Android Studio, when I click on a variable. It redirects me to where the variable was declared. Even, when coder writes lot of code than, it becomes hard to find "main" object by scrolling. Rub...

2 answers  ·  posted 1y ago by deleted user  ·  last activity 1y ago by ArtOfCode‭

71%
+3 −0
Why use an asterisk after a type?

#include&lt;stdio.h&gt; struct Node{ int data; struct Node* next; }; Here I used an asterisk after Node. What is it used for? What if I don't put any asterisk after Node (both Node...

2 answers  ·  posted 1y ago by deleted user  ·  edited 1y ago by hkotsubo‭

50%
+2 −2
Print value from constructor

#include&lt;iostream&gt; using namespace std; class Book{ public: string title; string author; int pages; Book(string aTitle, string aAuthor, int aPages){ aTitle = title; ...

1 answer  ·  posted 1y ago by deleted user  ·  edited 1y ago by Alexei‭

60%
+1 −0
Saving modified data in gridview on clicking SaveButton

I am struggling to do a save button in C# Windows Form Application where I have a GridView and I want to save all modifications I do in GridView Table(I connected it to SQL). This is the data sourc...

1 answer  ·  posted 1y ago by Cri‭  ·  edited 1y ago by Alexei‭

50%
+1 −1
Input taking only first character of a string

I wrote a program named Kernel.c 2 months into my life in programming and created 4 functions at the time, and now there are 7 functions. Recently, I updated the program completely onto an online ...

1 answer  ·  posted 1y ago by General Sebast1an‭  ·  last activity 1y ago by elgonzo‭

80%
+6 −0
How to do "out-of-source" build properly with cmake?

There are two broad types of build environments - in-source and out-of-source. "In-source" means the compiled files will appear in the same directory as source files. "Out-of-source" means there is...

2 answers  ·  posted 2y ago by anatolyg‭  ·  last activity 1y ago by alex‭

66%
+2 −0
Mixing "operational" database models with archiving ones in the database context

Context Our product owner has realized that some entities are duplicated from time to time and that a merge is required. This should clean up existing duplicates and also allow special users to me...

1 answer  ·  posted 1y ago by Alexei‭  ·  last activity 1y ago by meriton‭

50%
+2 −2
Accessibility standard/s for multilined <input type="text"> fields

I have a simple HTML contact form and I wish to create a text area in it with &lt;input type="text"&gt; but without a &lt;textarea&gt; tag. The end product should be an &lt;input type="text"&gt; f...

1 answer  ·  posted 1y ago by deleted user  ·  last activity 1y ago by hkotsubo‭

70%
+5 −1
Where did my proper divisor sum program went wrong?

Here in Python, I created a program for this challenge and I'm having trouble debugging it. I already fixed most errors I have on my program but here's what I have left: x=y=z=[];i=0.0;a=int(input...

1 answer  ·  posted 1y ago by General Sebast1an‭  ·  last activity 1y ago by hkotsubo‭

71%
+3 −0
How to create a MySQL generated column that uses a join in a concat?

I have a column that is a concatenation of 5 other columns plus a join to a different table. UPDATE db.a JOIN db.b ON fk_b = b.pk SET concat_field = CONCAT(field1,field2,field3,b.field,field4,fi...

1 answer  ·  posted 1y ago by Charlie Brumbaugh‭  ·  last activity 1y ago by Alexei‭

77%
+5 −0
Validate All Object Properties with JSON Schema

I'm writing a JSON schema to validate asset files for a program. The JSON I need to parse is structured so: { "jobs": { "software-developer": { "job-description": "sw-dev.md:0", "pay": 800...

1 answer  ·  posted 1y ago by Josh Hyatt‭  ·  last activity 1y ago by elgonzo‭

83%
+8 −0
How can I emulate regular expression's branch reset in Java?

I've got this sample regex: Pattern p = Pattern.compile("(?:([aeiou]+)[0-9]+|([123]+)[a-z]+)\\W+"); It basically has the following parts: one or more lowercase vowels ([aeiou]+), followed by one ...

2 answers  ·  posted 2y ago by hkotsubo‭  ·  last activity 1y ago by hkotsubo‭

77%
+5 −0
Freeing sub-process resources?

I'm using Python to invoke another program in a sub-process. I've noticed my memory sometimes gets so large as to crash the system, and I'm wondering if I'm not correctly cleaning up the memory som...

0 answers  ·  posted 1y ago by Hyperlynx‭  ·  edited 1y ago by Patol75‭

50%
+0 −0
Can Drupal be used to develop native (non web) applications?

I have used Drupal since 2010 to create websites and I recall a few years back reading that it can be used to create smartphone applications (or something similar). Is this only the "web-integrate...

1 answer  ·  posted 1y ago by deleted user  ·  last activity 1y ago by corporat‭

66%
+2 −0
Why content delivery networks often require a www. redirect?

Why do Content Delivery Networks are often developed in such a way that they would require adding a Cname value such as www. before example.com? I ask this after switching from one CDN (Cloudflare...

2 answers  ·  posted 1y ago by deleted user  ·  last activity 1y ago by corporat‭

33%
+0 −2
Is there a problem in making Captcha an HTML builtin with an attribute setting which type of Captcha

Many web login and contact form features could be set as standard HTML builtins without the need to develop and backend and/or (non HTML) frontend for them, for example: Select field Input Date...

2 answers  ·  posted 2y ago by deleted user  ·  last activity 1y ago by corporat‭

83%
+8 −0
How to set text-align for whole column of HTML table?

To start off, here is the complete HTML of a simple example table: &lt;html lang="en-US"&gt; &lt;head&gt; &lt;title&gt;Title&lt;/title&gt; &lt;style&gt; table { width: 20em; ...

2 answers  ·  posted 1y ago by Olin Lathrop‭  ·  edited 1y ago by Alexei‭

71%
+3 −0
How to retain a service's data between components in Angular 8 ?

I would like to maintain a log that is available to several modules in my Angular 8 system. So I created the following service: @Injectable({ providedIn: 'root' }) export class LogService { ...

1 answer  ·  posted 1y ago by nelson777‭  ·  last activity 1y ago by nelson777‭

77%
+5 −0
Modern CSS for splitting form sections into columns

I have a mobile-only HTML contact form divided in source code into three sections; each section should contain fields by a different context. &lt;!DOCTYPE html&gt; &lt;html&gt; &lt;head&gt; ...

1 answer  ·  posted 1y ago by deleted user  ·  edited 1y ago by Alexei‭

77%
+5 −0
Tools for debugging coredumps

For debugging running programs I often use whatever is integrated with the IDE I am using. QtDeveloper right now, but also used Eclipse, Netbeans and others. Most of them just use gdb under the hoo...

0 answers  ·  posted 1y ago by Estela‭  ·  edited 1y ago by Estela‭

75%
+4 −0
How to generate multi-line completions (code generation) with OpenAI?

I have finally received access to a trial account on OpenAI and I took it for a spin. My interest is with code generation, so first tried something simple using the playground: Q: generate a stand...

1 answer  ·  posted 1y ago by Alexei‭  ·  edited 1y ago by deleted user

66%
+2 −0
How to start mysql in Manjaro from terminal?

I had installed mysql using the following command sudo pacman -Sy mysql Earlier, I was using Lampp(Xampp for Linux) where I could start using the command /opt/lampp/start start I am not sur...

1 answer  ·  posted 1y ago by deleted user  ·  last activity 1y ago by deleted user

81%
+7 −0
Why is this client code getting the wrong date for a few hours a day?

Our web site has a widget that displays some date-based information that we retrieve from some JSON-formatted data (one object per date). We get the current date from the environment, possibly adj...

2 answers  ·  posted 1y ago by Monica Cellio‭  ·  last activity 1y ago by hkotsubo‭

60%
+1 −0
Is there any breaking change in regard to TrustServerCertificate property of System.Data.SqlClient for .NET 5?

I have recently an issue at work after upgrading an ASP.NET Core 3.1 application to .NET 5. It worked correctly on all environments (e.g. PreProd, Prod) when targeting 3.1, but failed on Prod only ...

1 answer  ·  posted 1y ago by Alexei‭  ·  last activity 1y ago by Alexei‭

28%
+0 −3
What makes a software module an "authentication" module?

As I don't have any significant experience with internationally-standard information security literature, I would like to ask here if some international information security organization took the i...

2 answers  ·  posted 2y ago by deleted user  ·  last activity 1y ago by nelson777‭

25%
+0 −4
Did functional programming predated Object oriented programming or rather the opposite?

By "functional" I don't mean "procedural" (i.e. I don't mean to programming which is done solely or primarily with these data structures commonly known as "functions" but are actually procedures), ...

2 answers  ·  posted 1y ago by deleted user  ·  last activity 1y ago by nelson777‭

75%
+4 −0
How can I customize the default project templates, or create my own, in Android Studio 4.2.1

I want to remove a deprecated entry from the default build.gradle file as well as change the default layout of an empty activity to use Relative Layout instead of constraint. I'm using Android Stu...

0 answers  ·  posted 1y ago by TecBrat‭

62%
+3 −1
Is the concept of a PHP lint feasible?

When I review JavaScript files in various text editors (Visual Studio Code, Greasemonkey/Tampermonkey) I sometimes get notified about syntax errors. I never encountered this behavior with PHP file...

2 answers  ·  posted 1y ago by deleted user  ·  last activity 1y ago by nelson777‭

php
33%
+1 −4
Convert .npy files in a directory to images (.png)

I have around 20,000 .npy files in a directory. That main directory has no subfolders:- Main_dir | |--1.npy |--2.npy |--3.npy |--........ The absolute file paths are stored ...

2 answers  ·  posted 2y ago by Neel_Gupta‭  ·  last activity 1y ago by hoverhell‭

70%
+5 −1
How do I get the error message out of a requests exception?

I'm trying to log error messages from Requests exceptions. Example: try: make_web_request() except RequestException as ex: logging.error(ex) Example output: ERROR : ('Connection abo...

2 answers  ·  posted 1y ago by ajv‭  ·  last activity 1y ago by hoverhell‭

71%
+3 −0
How to copy a PostgreSQL database to another machine.

I have to debug an error which seems to only happen with some set of data present in our PostgreSQL database. I'd like to copy said database to my local machine so I can perform tests without affe...

1 answer  ·  posted 1y ago by Estela‭  ·  edited 1y ago by Alexei‭

71%
+3 −0
How to pivot text?

In this Q a user asked for a simple way to represent this data: - PERSON 1 | PERSON 2 | YES - PERSON 1 | PERSON 3 | YES - PERSON 2 | PERSON 1 | YES - PERSON 2 | PERSON 3 | YES - PERSON 3 | PERSON 1...

2 answers  ·  posted 2y ago by pnuts‭  ·  last activity 1y ago by Alexei‭

60%
+1 −0
Trigger Conditional Formatting by Check Box

One part of an as yet unanswered Q on Super User asks whether conditional formatting in OpenOffice Calc can be used to highlight an entire row based on whether a checkmark in the row has been selec...

1 answer  ·  posted 2y ago by pnuts‭  ·  last activity 1y ago by Alexei‭

60%
+1 −0
A function to round negative numbers towards 0

Some while ago a user of Web Applications asked after a function to avoid "an if/else just to handle negative numbers properly". Clarification provided was: Presently it round based on absolute...

1 answer  ·  posted 2y ago by pnuts‭  ·  last activity 1y ago by Alexei‭

60%
+1 −0
Iterative references in LibreOffice Calc

An as yet unanswered Q from Stack Overflow [SO] enquired: how to stop looping this formula where the formulae were: in B9 =16,50 in B10 =B9-B11 in B11 =B10/2 without changing ...

1 answer  ·  posted 2y ago by pnuts‭  ·  last activity 1y ago by Alexei‭

57%
+2 −1
How to convert an RFC822 timestamp to a date index number?

A self-answered question - How to get DATEVALUE to recognize RSS 2 pubDate (RFC822)? - written by spcsLrg on Web Applications Stack Exchange offers this formula: =DATEVALUE(TRIM(REGEXREPLACE(A1,"^...

1 answer  ·  posted 2y ago by pnuts‭  ·  last activity 1y ago by Alexei‭

60%
+1 −0
Automatic adjustment when copying of column reference within INDIRECT function

An as yet unanswered question on Web Applications, INDIRECT cell reference - Can't copy cell as reference cell pattern remains same, from @Daniel Klose is: I have an Overview Sheet where I want to...

1 answer  ·  posted 2y ago by pnuts‭  ·  last activity 1y ago by Alexei‭

50%
+0 −0
In a column, set populated cells to 1 and empty cells to 0

In an as yet unanswered Q from early this year a user of Stack Overflow asked: how to fill all non-empty cells of a column by 1 and the empty cells by 0. It's an xlsx file open with LibreOffice ...

1 answer  ·  posted 2y ago by pnuts‭  ·  last activity 1y ago by Alexei‭

42%
+1 −2
How to add to the value of one cell an amount that depends upon the range of a different cell?

A user of Web Applications asked how to: +1 when the value is &gt;=5, +2 when the value is &gt;=10, +3 when the value is &gt;=15, +4 when the value is &gt;=20, +5 when the value is &gt;=25...

1 answer  ·  posted 2y ago by pnuts‭  ·  last activity 1y ago by Alexei‭

50%
+0 −0
How to calculate the Hamming weight of a binary string?

A presently unanswered question on Stack Overflow asks: Does there exist a popcount function in libreoffice calc? and clarifies that "I often use BASE(A1;2;8) to show a number in binary".

1 answer  ·  posted 2y ago by pnuts‭  ·  last activity 1y ago by Alexei‭

57%
+2 −1
Combine the first character of a cell with another cell

A Q on Stack Exchange from a very long time ago included: I have first names in one column and second names in another, I want to create a third column that contains the first character from the...

1 answer  ·  posted 2y ago by pnuts‭  ·  last activity 1y ago by Alexei‭

50%
+2 −2
Conditionally format a pair of columns

A user of Web Applications asked "How should I fix the formula?" with reference to: =IF($K4&lt;2,$K4) applied as a Conditional Formatting [CF] formula to J4:J8, where the desired (green fill) form...

1 answer  ·  posted 2y ago by pnuts‭  ·  last activity 1y ago by Alexei‭

50%
+1 −1
Count the number of occurrences in a text string

The question about LibreOffice Calc - Number of occurrences in text string from Binz Nakama at Stack Overflow interested me because of one of the comments posted there: OK, I think this would requ...

1 answer  ·  posted 2y ago by pnuts‭  ·  last activity 1y ago by Alexei‭

80%
+6 −0
Multiple string concatenation in Excel

In Excel I would like to concatenate several strings into one. I could type and fill in the blanks CONCATENATE(A1, A2, ....) but it is a lot of work This would be cool, but it does not work CONCATE...

2 answers  ·  posted 2y ago by James Jenkins‭  ·  last activity 1y ago by Alexei‭

50%
+0 −0
Merge a pair of columns where in each row one is blank, without a formula

A Q on Stack Overflow asks how to merge two columns where each row has only one populated cell. The example was from (on the left) to (on the right): a|b a 0| ...

0 answers  ·  posted 2y ago by pnuts‭  ·  last activity 1y ago by pnuts‭

50%
+0 −0
Copy a sparse matrix with removal of blanks

A user of Web Applications gave the following as an example: https://docs.google.com/spreadsheets/d/1nPTBFXaIgpruPgNoWFSBUL2yKaibjeNJNExhnHVr8LE/edit#gid=0 and asked: How do I read a long ro...

0 answers  ·  posted 2y ago by pnuts‭  ·  last activity 1y ago by pnuts‭

50%
+0 −0
Loss of precision when concatenating an exchange rate with a string

In response to a Q on Web Applications [WA] the asker self-answered with: =CONCATENATE("@ £/€ rate: ",text(J21,"0.00000")) The issue was that, with "in a cell J21 I have a set value 1.10000":. ...

0 answers  ·  posted 2y ago by pnuts‭  ·  last activity 1y ago by pnuts‭

50%
+0 −0
A Conditional Formatting formula rule expected to apply to all cells is only affecting some

A very recently asked Q on Web Applications has no answer yet (and, in my opinion, is so badly written may not receive an answer at all promptly). However it does seem (in my interpretation) to rai...

0 answers  ·  posted 2y ago by pnuts‭  ·  last activity 1y ago by pnuts‭

66%
+2 −0
Highlight the maximum value per row across multiple columns

An as yet unanswered OpenOffice Calc - Highlighting the higest value in multiple columns posted by Rui on Super User from early this year asked whether a condition was possible to: fill with a c...

0 answers  ·  posted 2y ago by pnuts‭  ·  last activity 1y ago by pnuts‭