All Questions
Tagged with string-concatenation or concatenation
14,259 questions
1
vote
1
answer
146
views
SQL Query Resulting in Multiple Rows
The database I'm working in is Snowflake. I also have to work through an interface and can't edit the SQL query directly. I'm trying to add a JOIN to a FROM clause that is connecting two schemas with ...
- 31
2
votes
1
answer
112
views
Concatenate Tables Based on Column Information in Python [duplicate]
I have a dataframes pulled from a file. The variable with all these dataframe names is: Data_Tables.
These dataframes all have the same columns, and I want to concatenate the dataframes based on the ...
- 55
0
votes
1
answer
38
views
Power Query Concatenate and If statement
I want to add a custom column to concatenate several columns with some if statements. I am getting a "Token 'else' expected error message. Can you please tell me what I forgot or did wrong? Power ...
3
votes
1
answer
142
views
postgres: parameterized query with pattern matching
in node, i'm creating the following query:
let sql_query = "\
SELECT \
... \
WHERE \
FACILITY_ID = $1 \
AND (EVENT_START_TIME_UNIX_MS < $2) \
AND (...
- 335
1
vote
0
answers
49
views
Bundle selected CSS files to a single output file
How to combine multiple CSS files into a single output file?
In SASS, this was done in a SCSS file by adding in other SCSS files via the @use method.
I have found that this can be done by adding in ...
- 20.6k
1
vote
1
answer
60
views
Search for multiple different strings in the same set of multiple columns [duplicate]
I need to search for multiple different strings in the same set of multiple columns in a MySQL table.
Here's one way that works (CONCAT / CONCAT_WS):
SELECT * from some_table WHERE
LOCATE('word1', (...
- 21
0
votes
0
answers
90
views
How to use CONCAT to combine first and last names of a company's customers in a single expression?
The first and last names of customers are found in separate columns and they need to be combined to enable proper analysis. I tried using the CONCATENATE function in Google Sheets and the full names ...
0
votes
2
answers
117
views
Write data to Excel cells, update formulas, and then continue with updated values
I am working on an interactive Excel project.
I have a series of UserForms that take user-entered data and writes them to cells.
In the final UserForm in the sequence, data is written to a final cell.
...
- 65
1
vote
1
answer
55
views
Combine two pandas Dataframes with Timestamp Index
I have two dataframes with timestamp data. It is sensor readouts from different sources.
I want to combine them. The left dataframe (df1) can be quite large as it will be a combination of multiple ...
- 11
0
votes
1
answer
75
views
MariaDB :Producing an insert from another table with concat
I want to produce an insert out of a table for another table with concat.
All works well, besides a little devil ...
At the end of the concat I get an ' after the ;
Without the ' it works all well.
...
- 119
1
vote
1
answer
80
views
Concatenate two Polars string columns or a fixed string to a column
How do I concatenate two string columns horizontally or append a fixed string to a column?
- 11.5k
0
votes
1
answer
25
views
In C, how do I use a single hex value in both an enum and a const char *
I have a function that allows access to system variables based on a lookup code. The lookup code has an enum type.
typedef enum SystemVariable_e {
INT_SYSTEM_VAR_1 = 0x10,
INT_SYSTEM_VAR_2 = 0x20
...
0
votes
1
answer
86
views
Hexadecimal concatenation in recursive CTE is truncated to 64 characters
I'm working on Nested Set Hierarchies. I'm using a recursive CTE to build the nested equivalent of adjacency list table. MySQL 8.4 is my platform.
-- adjacency list table
CREATE TABLE dct_node_adjc
(
...
1
vote
1
answer
73
views
Numpy Concatenate Replacing Previous Data in Array
I am trying to write code that produces a deck of cards. The deck is a 2D array that contains each card as an array. Each card array contains its card value as well as its suit, represented by the ...
- 21
1
vote
2
answers
51
views
Python DataFrame structure breaks when appending the File
I am trying to get user inputs to create a file where users can store website, username, and password in table format whenever users hit a button. I made the function below, and it looks okay to me. ...
- 13