CSV file having multiple comma's in single column

Question

how to create CSV file having multiple comma's in single column? e.g. id,description 101,abc,def 102,ghj

Manoj Bhoir · Answer

Hi, Check this sample code : using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.IO; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; namespace WindowsFormsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { using (StreamWriter sw = File.CreateText("d:\TestCSV.csv")) { sw.WriteLine("1, 2, 3"); sw.WriteLine("4, 5, 6"); sw.WriteLine(""7, 8", 9 , 10"); } } } }

Saber Shaikh · Answer

only set the Sql Query youcan Get Out put Like SELECT column1 , column2 +','+ column3 As Desc FROM Tbl_Name then use this Code only datatable Export http://www.aspsnippets.com/Articles/Export-data-from-SQL-Server-to-Excel-in-ASPNet-using-C-and-VBNet.aspx

Harminder Singh · Answer

just tell me how to replace space "" from string builder that i earlier replace with ,

Harminder Singh · Answer

check this

Saber Shaikh · Answer

give me screen shot of excel sheet what you want to Id des 1 abc 2 def

Saber Shaikh · Answer

if (dataTable.Columns.Count != 0) { sbldr.Append(string.Join(", ", dataTable.Columns.OfType ())); sbldr.Append("
"); for (int i = 0; i { sbldr.Append(string.Join(", ", dataTable.Rows.OfType ().Select(r => r[i].ToString()))); sbldr.Append("
"); } } Use this

Harminder Singh · Answer

But i am using string builder... then how to do??? my code is given below Response.Clear(); Response.Buffer = true; Response.AddHeader("content-disposition", "attachment;filename=DATA.csv"); Response.Charset = ""; Response.ContentType = "application/text"; StringBuilder sbldr = new StringBuilder(); if (dt.Columns.Count != 0) { foreach (DataColumn col in dt.Columns) { sbldr.Append(col.ColumnName + ','); } sbldr.Append("
"); foreach (DataRow row1 in dt.Rows) { foreach (DataColumn column in dt.Columns) { sbldr.Append(row1[column].ToString().Replace(',',' ') + ','); } sbldr.Append("
"); } } Response.Output.Write(sbldr.ToString()); Response.Flush(); Response.End();

Saber Shaikh · Answer

use with your logic string[] arr = { "one", "two", "three" }; // "string" can be lowercase. Console.WriteLine( string.Join ( "," , arr)); // ... "String" can be uppercase. Console.WriteLine( String.Join ( "," , arr)); Output one,two,three one,two,three My blog

CSV file having multiple comma's in single column

Answers (8)