How to create a SQL Server function to "join" multiple rows from a subquery into a single delimited field?

To illustrate, assume that I have two tables as follows: VehicleID Name 1 Chuck 2 Larry LocationID VehicleID City 1 1 New York 2 1 Seattle 3 ...

What is the string concatenation operator in Oracle?

What is the string concatenation operator in Oracle SQL? Are there any "interesting" features I should be careful of? (This seems obvious, but I couldn't find a previous question asking it).

How slow is Python's string concatenation vs. str.join?

As a result of the comments in my answer on this thread, I wanted to know what the speed difference is between the += operator and ''.join() So what is the speed comparison between the two?

string concatenation problem

Please how this string concatenation taking place? i am really confuse what is happening why that slash i there and how the double quotes are used SessionStateItemCollection items = new...

Determining the individual letters of Fibonacci strings?

The Fibonacci strings are defined as follows: The first Fibonacci string is "a" The second Fibonacci string is "bc" The (n + 2)nd Fibonacci string is the concatenation of the two previous...

C++ Literal String Concatenation

I have a question about string concatenation in C++. string str = "ab" + 'c'; cout << str << endl; char ch = 'c'; string str1 = "ab"; string str2 = str1 + ch; cout << str2 <<...

_bstr_t concatenate gives 12142

I have a strange thing here. I'm concatenating _bstr_t strings in order to assemble a SQL command. _bstr_t strSQL = a+b+k+hk+Allin+hk+k+hk ...and so on. When I print it to the console (using...

String concatenation in MySQL

I am using MySQL and MySQL Workbench 5.2 CE. When I try to concatenate 2 columns, last_name and first_name, it doesn't work : select first_name + last_name as "Name" from test.student

How to collapse a list of characters into a single string in R

There is a list which I would like to output into an excel file as a single string. I start with a list of characters. ...

R create strings in a loop

How can I create variables and strings using the value passed by the loop? Example I have a set of countries = c('USA','Canada','Mexico'). I have a dataframe 'population'. I want to query my...

String concatenation of two pandas columns

I have a following DataFrame: from pandas import * df = DataFrame({'foo':['a','b','c'], 'bar':[1, 2, 3]}) It looks like this: bar foo 0 1 a 1 2 b 2 3 c Now I want to have...

send sms with an operator using smpp and kannel

I work with ubuntu 10.10 currently I send sms with clickatell using this code Message = space_to_plus("message de test."), Url =...

Getting the character length of a string literal

How would you get the length (Give or take the null-terminator) of a string literal without using the cstdlib of something like this: char* foo = "foobar"; cout << sizeof(foo) << endl; //Always...

nvarchar concatenation / index / nvarchar(max) inexplicable behavior

I today ran into a really weird problem in SQL Server (both 2008R2 and 2012). I'm trying to build up a string using concatenation in combination with a select statement. I have found workarounds,...

Different results with base64 encoding in Google Apps Scripts and JavaScript

I have tested the following statements in Google Apps Scripts and were surprised that they yield different results var a = Base64.encode(ciphertext); var b =...

Creating a hyperlink with a String in Text cell trims 0s

I created a sub to create hyperlinks in my Excel 2010 workbook, and it works for all my purposes except one. I have a use case where the sub is supposed to create a link with a task number for the...

Is there a string concatenation shortcut in PowerShell?

Like with numerics? For example, $string = "Hello" $string =+ " there" In Perl you can do my $string = "hello" $string .= " there" It seems a bit verbose to have to do $string = $string + "...

How do I concatenate strings in Swift?

How to concatenate string in Swift? In Objective-C we do like NSString *string = @"Swift"; NSString *resultStr = [string stringByAppendingString:@" is a new Programming Language"]; or NSString...

String concatenation in solidity?

how do i concatenate strings in solidity? var str = 'asdf' var b = str + 'sdf' seems not to work.. I looked up the documentation...

How can I pass two values (lat lng) to one parameter key of GET request using JS?

I am trying to make a request call on the Yelp API (https://www.yelp.com/developers/documentation/v2/search_api). However, I came across a problem with trying to pass in two value of lat lng...

Safely concatenate multibyte strings

I'm looking increasingly into ensuring that PHP apps are multibyte-safe, which mostly involves replacing string manipulation functions with their equivilant mb_* functions. However string...

Compose dynamic SQL string with psycopg2

I use psycopg2 in python (2.7.10) to connect to a postgresql DB. The docs are pretty clear about composition of dynamic SQL statements: Never, never, NEVER use Python string concatenation (+) or...

multiple if else conditions in pandas dataframe and derive multiple columns

I have a dataframe like below. import pandas as pd import numpy as np raw_data = {'student':['A','B','C','D','E'], 'score': [100, 96, 80, 105,156], 'height': [7, 4,9,5,3], ...

Java - 12 H to 24 Hour Format (hackerrank)

*Note :* I looked as much as I could for 2 days to check if this is a duplicate. If I missed something, I apologize. This question is to find what the issue is with my attempt at a solution, not...

NSAttributedString boundingRect returns wrong height

I calculate the height of an NSAttributedString like this. let maxSize = NSSize(width: w, height: CGFloat.greatestFiniteMagnitude) let rect = boundingRect(with: maxSize, options:...

Coinbase Pro API - invalid signature

This is edited from original post: From the docs: Signing a Message The CB-ACCESS-SIGN header is generated by creating a sha256 HMAC using the base64-decoded secret key on the prehash...

How to turn off string concatenation optimization

In Java 9 Oracle improved String concatenation. Now "" + someBoolean turns into invokedynamic with StringConcatFabric.makeConcat as bootstrap method. That fabric generates classes at runtime that...

IMPORTRANGE built dynamically, pulls in as string when it lands in cell instead of the formula

I'm building linked google sheets. In the scenario I need to build the IMPORTRANGE formula dynamically from a concatenation. The IMPORTRANGE formula which I want to populate in the cell is:...

Problem Updating to .Net 6 - Encrypting String

I'm using a string Encryption/Decryption class similar to the one provided here as a solution. This worked well for me in .Net 5. Now I wanted to update my project to .Net 6. When using .Net 6,...

Merging clips with AVFoundation creates single video in black

I am using AVFoundation to merge two videos into one. The result of my attempt is a single video with a length equal to the sum of all the clips, and displaying a black screen. Here is my code: ...