#string-concatenation

Answer: How to use GROUP BY to concatenate strings in SQL Server? #computers #dev #development

How to use GROUP BY to concatenate strings in SQL Server?

How do I get:

id Name Value 1 A 4 1 B 8 2 C 9

to

id Column 1 A:4, B:8 2 C:9

Answer [by Dana the Sane]: How to use GROUP BY to concatenate strings in SQL Server?

I’ve looked for ways to do this before, and besides writing a stored proc, there isn’t an easy way to do it. I resort to writing a script or using an ETL tool like Talend to do…

Solution: Using Linq to concatenate strings #programming #answer #dev

Using Linq to concatenate strings

What is the most efficient way to write the old-school:

StringBuilder sb = new StringBuilder(); if (strings.Count > 0) { foreach (string s in strings) { sb.Append(s + ", "); } sb.Remove(sb.Length - 2, 2); } return sb.ToString();

…in Linq?

Answer [by Robert S.]: Using Linq to concatenate strings

Have you looked at the Aggregate extension method?

var sa = (new[]…

How-to: String concatenation and Ruby #computers #solution #programming

String concatenation and Ruby

I am looking for a more elegant way of concatenating strings in Ruby.

I have the following line:

source = "#{ROOT_DIR}/" << project << "/App.config"

Is there a nicer way of doing this?

And for that matter what is the difference between << and +?

Answer [by Keltia]: String concatenation and Ruby

You can do that in several ways:

As you shown with <<but that is not…

How to: How to efficiently concatenate strings in Go?

How to efficiently concatenate strings in Go?

In Go, string is a primitive type, it’s readonly, every manipulation to it will create a new string.

So, if I want to concatenate strings many times without knowing the length of the resulting string, what’s the best way to do it?

The naive way would be:

s := ""; for i := 0; i < 1000; i++ { s += getShortStringFromSomewhere(); } return s;

but that…

How to: How to concatenate strings of a string field in a PostgreSQL 'group by' query?

How to concatenate strings of a string field in a PostgreSQL ‘group by’ query?

I am looking for a way to concatenate the strings of a field within a group by query. So for example, I have a table:

ID COMPANY_ID EMPLOYEE 1 1 Anna 2 1 Bill 3 2 Carol 4 2 Dave

and I wanted to group by company_id to get something like:

COMPANY_ID EMPLOYEE 1 Anna, Bill 2 Carol, Dave

There is a built-in function in…

How to: How to use GROUP BY to concatenate strings in SQL Server?

How to use GROUP BY to concatenate strings in SQL Server?

How do I get:

id Name Value 1 A 4 1 B 8 2 C 9

to

id Column 1 A:4, B:8 2 C:9

Answer: How to use GROUP BY to concatenate strings in SQL Server?

I’ve looked for ways to do this before, and besides writing a stored proc, there isn’t an easy way to do it. I resort to writing a script or using an ETL tool like Talend to do this.

Answer: How…

Fixed Concatenate many rows into a single text string? #dev #it #asnwer

Concatenate many rows into a single text string?

Consider a database table holding names, with three rows:

Peter Paul Mary

Is there an easy way to turn this into a single string of Peter, Paul, Mary?

Answer: Concatenate many rows into a single text string?

Depends on your database vendor. MySQL has concat_ws. MS SQL Server expects you to do it in your client application.

Update: you could also…

How to: Using Linq to concatenate strings

Using Linq to concatenate strings

What is the most efficient way to write the old-school:

StringBuilder sb = new StringBuilder(); if (strings.Count > 0) { foreach (string s in strings) { sb.Append(s + ", "); } sb.Remove(sb.Length - 2, 2); } return sb.ToString();

…in Linq?

Answer: Using Linq to concatenate strings

Have you looked at the Aggregate extension method?

var sa = (new[] { "yabba",…