Convert object to CSV string

Question

I am having problems converting an object of products into a csv string.

var data = ProductPresenter.ExportAllProducts();
string csv = String.Join(",", data.Select(x => x.ToString()).ToArray());

This produces an output of:

BLL.Views.ExportAllProducts,BLL.Views.ExportAllProducts,BLL.Views.ExportAllProducts,BLL.Views.ExportAllProducts,BLL.Views.ExportAllProducts,BLL.Views.ExportAllProducts,BLL.Views.ExportAllProducts,BLL.Views.ExportAllProducts,BLL.Views.ExportAllProducts,BLL.Views.ExportAllProducts,BLL.Views.ExportAllProducts,BLL.Views.ExportAllProducts,BLL.Views.ExportAllProducts,BLL.Views.ExportAllProducts,BLL.Views.ExportAllProducts,BLL.Views.ExportAllProducts,BLL.Views.ExportAllProducts,BLL.Views.ExportAllProducts

Expected output would be like:

Small Hat, 12.10, true
Medium Hat, 13.50, true
Large Hat, 15.00, false
...

What conversion am I missing to get the values out of each item on the object?

What does the ExportAllProducts method do? Could you show us some code? — Thomas C. G. de Vilhena
– Thomas C. G. de Vilhena, Commented Dec 26, 2013 at 17:50
By default, .ToString() on a reference type just prints the name of the type. What is the type of data? Have you overridden the default behavior of .ToString() on it? — David
– David, Commented Dec 26, 2013 at 17:52
I would assume ExportAllProducts returns an array of objects and therefore the string.join returns an "{object}","{object}" sort of array and not the result join of all properties of the object — Dalorzo
– Dalorzo, Commented Dec 26, 2013 at 17:57
Does this answer your question? Fastest way to convert a list of objects to csv with each object values in a new line — Jim G.
– Jim G., Commented Mar 16, 2023 at 15:09

T McKeown · Accepted Answer · 2013-12-26 17:51:49Z

4

Your data variable is not a list of strings, either add a .ToString() method to that class or create a list of strings and use that.

answered Dec 26, 2013 at 17:51

T McKeown

12.9k1 gold badge27 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

asm00 · Accepted Answer · 2013-12-26 17:54:59Z

1

You need to override ToString() method in order to have the desired effect. Otherwise, the implementation of ToString() from the base "Object" class is used when you do x.ToString().

Object.ToString() returns the full name of the class of which your object is an instance of.

answered Dec 26, 2013 at 17:54

asm00

7096 silver badges7 bronze badges

Comments

Vland · Accepted Answer · 2013-12-27 00:46:00Z

0

I think you're trying to get a list/array of strings in csv format.

I'd override ToString()

class Product
{
    public override string ToString()
    {
        return ProductName + "," + Price.ToString() + "," + boolProperty.ToString();
    }
}

and

var q = (from d in data select d.ToString()).ToArray()

or something like

var q = (from d in data 
        select new { d.ProductName + "," + Price.ToString() +
               "," + boolProperty.ToString() } )
        .ToArray()

edited Dec 27, 2013 at 0:46

answered Dec 26, 2013 at 18:06

Vland

4,2822 gold badges36 silver badges45 bronze badges

Collectives™ on Stack Overflow

Convert object to CSV string

3 Answers 3

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Linked

Related