All Questions
Tagged with string-concatenation or concatenation
14,257 questions
3
votes
1
answer
66
views
How can I create a table using ARRAYFORMULA that concatenates all items meeting the same criteria in one cell?
Sample spreadsheet
I've been trying for the life of me to figure out how to do this and cannot.
I have a table: ColA is items, ColB is their category.
Item
Category
Apple
Fruit
Orange
Fruit
...
- 33
1
vote
1
answer
164
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
121
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
45
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
149
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
51
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
64
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
94
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
122
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
60
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
77
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
90
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.6k
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
89
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
60
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
-2
votes
1
answer
358
views
How do I concatenate a range of cells into a single cell in Excel? [duplicate]
I want to concatenate the data from each column of a row in an Excel into a single cell. So for example, if I had the following:
first_name last_name country
Demetra Ioannou US
Emmalyn ...
- 27.8k
-1
votes
1
answer
71
views
Using wildcards in JavaScript [duplicate]
I'm writing a program which generates random letters and determines if there exists a word containing those letters in the order they're generated.
No matter which letters are generated, the program ...
0
votes
2
answers
98
views
Excel CONCATENATE that includes " in the result
I need to CONCATENATE a large table, so I can create a .csv string for a file import. The issue is that the system requires that all text fields are separated by ". In a CONCATENATE I am unable ...
- 10.2k
0
votes
1
answer
74
views
How to detect the edge of concatenations images by computer vision? [duplicate]
sample input image1
I would like to use computer vision to detect the edge like this
image2
I wonder if there were some image process algorithms that could help me?
Note that some image could be ...
0
votes
0
answers
50
views
Find the page in a 3D matrix that is closest to a given matrix
One can easily concatenate (stack up) four arrays by using:
B = cat(3, A, A, A, A); % here A is 2-dimensional M x N matrix and B is 3-dimensional M x N x 4 stack
How is it possible to concatenate (...
- 2,341
0
votes
0
answers
30
views
How to have a clean transition when concat MTS files using ffmpeg?
I have been struggling for a while and I hope someone can help me.
What I want to do:
1- seek MTS files
2- conact them without re-encoding them
How I do that:
I write a file concatList.txt
file 'file1....
- 1
1
vote
1
answer
69
views
Is there a way to optimize concatenation of files instead of appending file data to a python list?
I'm making a file compiler that takes data from csv files and after every 8 files read concatenates the data into a separate csv file. The program is taking quite long to be able to do these functions....
0
votes
1
answer
120
views
Building large complex lists in excel, using multiple parameters to determine list content
I have a spreadsheet which I use to record species presence and abundance within a number of woodland zones (see excerpt below). The spreadsheet also contains a lot of other data about each species.
...
- 101
0
votes
1
answer
37
views
CTE CONCAT not joining strings
I'm new to SQL. I'm using MySQL Ver 15.1 Distrib 10.3.27-MariaDB. For the following. I'm trying to compute paths in a graph like this: a->b.
create table edges
(
start varchar(4),
end ...
- 113
0
votes
0
answers
31
views
How to concatenate text from multiple rows into one row and one text string [duplicate]
I have
ID Name City Text
---- ----- ----- ------
1 Michael London Hey this is text
1 Michael London that should be merged together
to this:
ID ...
- 155
3
votes
1
answer
124
views
How Java internally processes `String` concatenation operator `+` in a chain?
Here is the code:
import java.util.Random;
public class StringConcatCompilerOptimization
{
private static long compute() {
var random = new Random();
var l = random.nextLong();
...
- 3,925
3
votes
2
answers
69
views
postgresql concat error when used in function
PostgreSQL syntax error when using CONCAT in user defined function.
Using DbVisualizer as SQL client.
CREATE FUNCTION t() RETURNS TEXT
AS ' SELECT CONCAT('some', '_text') ; '
LANGUAGE plpgsql;
[Code:...
- 31
1
vote
4
answers
108
views
Concatenate Column Y values for each Column X Date entry
I have a copy-paste data from a bank that looks as below. The problem is that the data is looks as below. Each transaction is recorded as row-wise for a given date. However, the description of each ...
- 53
0
votes
1
answer
66
views
Google Sheet formula for concatenation [duplicate]
Names
Value
Jack
A2
Jack
A3
Jack
A4
Tom
A5
Tom
A6
How can I join all values in "Value" column in one cell that map to each name in Column Names? Also, have another column that counts the ...
- 11
4
votes
1
answer
50
views
Removing unwanted connecting line with np.concatenate
Just for fun, I wanted to draw a circle and then continue into the sine wave for this circle.
Now, I have an error that I can't seem to get around: the " tail," which erases the circle, is ...
- 41
1
vote
1
answer
48
views
How to concatenate number (1'b1) and `define in a single statement
I am writing a test bench in which I am trying to define a bit stream like so:
`define PREAMBLE (10'b1010101011)
`define FUNC_ENERGY (4'b0001)
reg bit_stream_tb = {`PREAMBLE, `FUNC_ENERGY, 1'b1};
...
- 35
0
votes
0
answers
96
views
Reindexing only valid with uniquely valued index objects
There are a couple of articles about this issue already, but none of them solve my issue.
I have two sets of Python dataframes (df_A1, df_A2 and df_B1, df_B2) and I want to combine the A's together ...
- 567
-1
votes
1
answer
54
views
Substitute /Concatenate
The apostrophe is this string is breaking a power automate flow. I would like the name to just be "Sheerin, Jon" Instead of "Sheerin, Jon O'Hare" and remove everything else after ...
-1
votes
1
answer
125
views
More efficient way to perform np.hstack
I detected that the np.hstack operation over a list of arrays is a bottleneck in my pipeline and I would like to have a more efficient way to perform the concatenation.
Here a sample code to get to ...
- 155
0
votes
1
answer
73
views
How to combine multiple rows of a column while deduping the values in the column? [duplicate]
How can I get the result specified below?
I tried using the LISTAGG function, but it does not eliminate duplicates.
Is there a way to eliminate duplicates at the database itself instead of fetching ...
- 125
-1
votes
1
answer
49
views
Python - Concatenate data attributes of a class
I have a class
class Phone:
def __init__(self, brand, name):
self.brand = brand
self.name = name
phone = Phone("apple", "iphone3")
So I want to concatenate ...
- 39
0
votes
0
answers
29
views
Combine two dataframes with partially overlapping column values [duplicate]
Hi :) I want to combine two dataframes, I have been looking on this site in the hopes of getting an answer but I still could not figure it out.
My first dataframes looks like this (I put it as table ...
- 3
-3
votes
1
answer
35
views
Basic Programming Concepts [duplicate]
Why does my Python code raise a TypeError when trying to concatenate a string and an integer?
I tried concatenating a string and an integer like this:
message = name + "is" + age
I was ...
1
vote
1
answer
247
views
How to trigger inline script onload?
I have the following script, as seen, it calls the Date method onClick event, like so:
<!DOCTYPE html>
<html>
<body>
<p onclick='this.innerHTML = Date();'>click me!</...
- 3,160
0
votes
1
answer
37
views
Concatenate values with "/" separator in XSLT 1.0
I have XML with product's parameters like colors.
<parameter name='color'>
<value>black</value>
<value>white</value>
</parameter>
I want to output a value ...
- 13
3
votes
2
answers
146
views
std::string concatenation in C++
What is the principle of std::string concatenation in C++ ? How does it works in memory allocation ?
I found out while exploring a leetcode card that in Java:
"concatenation works by first ...
- 33
-1
votes
2
answers
60
views
Use of inline if/then/else in Javascript [closed]
Is it possible to use inline conditional statements in concatenation?
For instance,
console.log("<b>Test :</b> " + "null" == "null" ? "0" : "1"; + "<br>")
produces an error....
- 194
1
vote
1
answer
69
views
PS: Add-Content Get-Date & concatenate variable
I have a variable called BB_NP and I want to add the contents of that (string) to an output text file with a date/time, so just a basic log file.
Add-Content -Path ".\LogFile.txt" -Value $(...
- 33
1
vote
3
answers
94
views
c++ manual concatenation of c-strings function that is called twice and adds a space
I have an assignment to write a function that takes two C-string parameters and appends the second to the first just like the strcat function but without using said function. Then, write a main driver ...
- 11
-2
votes
1
answer
84
views
Why can't I stack 3D arrays with np.concatenate in numpy, while 1D and 2D arrays work?
I'm working with 3D numpy arrays and having trouble stacking two of them. Here’s what I’m trying to do:
import numpy as np
grid = np.arange(16).reshape((1, 4, 4))
grid2 = grid[:, :-1, ::-1].copy()
I ...
0
votes
2
answers
48
views
Append a value to a single df column, without concatenating a row
I have a pandas df where each column have some numerical values, followed by some NaNs. The number of values and NaNs differ between columns. I want to append a single value at 'first non-NaN position'...
-1
votes
1
answer
73
views
Why is my data not getting properly concatenated?
I split the data using train_test_split after preprocessing:
from sklearn.model_selection import train_test_split
X_train,X_test,y_train,y_test= train_test_split(X,y,test_size=0.2,random_state=42)
...
