Create a comma separated string from multiple rows of a column?

I've an access table like this

ID | UserName | CarBrand
-------------------------
0    Peter      VW
1    Peter      Ferrari
2    Mike       Audi
3    Peter      Dodge
4    Heidi      BMW
5    Heidi      Ford

I need the names from the CarBrand field as a comma separated list for a report.

Is there a way (without VB, maybe using a COALESCE alternative?) to create a comma-separated string like this, without the Name: part?

Peter: VW, Ferrari, Dodge
Mike:  Audi
Heidi: BMW, Ford

As it's for a report are there any other ways to do this, maybe using expressions in the report?

You cannot do this is Access without VBA. Coalesce does not exist, but you can write a UDF that has some of the functionality, for example http://allenbrowne.com/func-concat.html However, once you use a UDF, the query is no longer viable outside Access.

How to create a comma-separated string from an array of query results in php codeigniter

I have a query which returns an array of values. My task is to convert this results as comma separated values like: value1,value2....valuen I tried using explode and implode.. But it didnt worked. May be am not using it in the proper way..Here's my c

Create a comma-separated string from numeric values with multiple formats

I am creating a string with a list of comma separated values, but these numeric values have different formats. Currently I am using something like this: var values = new StringBuilder(); // These are all of type double values.AppendFormat("{0:F1},&qu

Create a comma-separated string from the list

I have a class called user that contains a list of groups that are strings ( Group A, Group B, Group C) public class User { public string FirstName { get; set; } public string LastName { get; set; } public User() { Groups = new List<string>(); } } I

Get a comma-separated value from multiple rows in sql server 2005

i have this table Cream ---------- CHOCALATE GREEN TEST want out put in select query like this cream CHOCALATE,GREEN,TESTWith sysobjects this worked: DECLARE @List varchar(2000) SELECT @List = COALESCE(@List + ',', '') + Cast(name As varchar(50)) FRO

Creating comma-separated strings from a custom collection

I have List<Accrual> and List<Brand> (and many other similar objects) as mentioned below. I need to create a comma separated string from a List<string> using String.Join public static string GetCommaSeparatedString(List<string> inp

Read all unique cell values in a range and create a comma-separated string of them?

I have written the following function to read all unique values from cells in a range and create a comma separated string from them? Is there a better, simpler way to do this? Private Sub CsvUniqueValues(r As Excel.Range) Dim c As Excel.Range Dim s A

Python: Creating a Comma-Separated String of a Query

I have a query messages = Message.objects.all() I want to create a Create a comma separated string of all numbers from message.number This is what I have tried: number = "" for obj in messages: number = number + "," + obj.number How ca

Creating a comma separated list from IList & lt; string & gt; or IEnumerable & lt; string & gt;

What is the cleanest way to create a comma-separated list of string values from an IList<string> or IEnumerable<string>? String.Join(...) operates on a string[] so can be cumbersome to work with when types such as IList<string> or IEnume

Comma Separated List from Multiple Columns

I have data that looks like this: CUSTOMER_ID OPERDAYSJUL OPERDAYSAUG OPERDAYSSEP ... OPERDAYSJUN 1 30 15 2 2 5 1 0 3 6 0 12 4 12 5 23 For each customer_id, I want a comma-delimited list indicating which months the customer operates: CUSTOMER_ID OPER

How to create a comma separated list from a nested array in PHP

I'm having little bit of confusion in this array.. Actually I'm having an array like this Array ( [0] => stdClass Object ( [restaurant_id] => 1 [food_item] => Chicken Spicy Pizza ) [1] => stdClass Object ( [restaurant_id] => 1 [food_item] =

Concatenating strings from multiple rows into a file separated by new rows

If I have a file with multiple lines like: name1 12345 67890 name2 23456 78901 name3 34567 89012 How would I go about concatenating each line in the form: "name1 1234567890" "name2 2345678901" "name3 3456789012" Specifically,

Can not create a comma-separated list from my table

I'm a newbie in PHP. Here's my code: $email_db = mysql_query("SELECT emails FROM email_feeds") or die(mysql_error()); $recipients = array(); while($row = mysql_fetch_assoc( $email_db )){ $recipients[] = $row; } $sendTo = implode(', ', $recipient

Remove the comma-separated string from EntitySet & lt; & gt;

How do I convert EntitySet<> to a String? i.e. (bob, joe, frank)? In the below LINQ ContactType is a seperate table that can have numerous values. I am trying to convert it into a comma seperated string. var caseNotes =context.tblCaseNotes .Where(cn

How to create a comma delimited string from an ArrayList?

I'm storing an ArrayList of Ids in a processing script that I want to spit out as a comma delimited list for output to the debug log. Is there a way I can get this easily without looping through things? EDIT: Thanks to Joel for pointing out the List(

Related Articles