<div>
<div class="content wysiwyg-content">
I am exporting a file in excel csv format. However, there are text fields that contain commas, so the comma delimeter sends them off to the next column prematurely.<br />
<br />
How do I either change the delimiter to something else so that I can keep my text and commas in the correct column. Or how do I escape the commas.<br />
<br />
And &nbsp;do I have to escape quotes and wrap quotes? I've been googling and finding all kinds of info on quotes, but nothing on fixing my comma issue.<br />
<br />
thanks!
</div>
</div>


I am exporting a file in excel csv format. However, there are text fields that contain commas, so the comma delimeter sends them off to the next column prematurely.

How do I either change the delimiter to something else so that I can keep my text and commas in the correct column. Or how do I escape the commas.

And  do I have to escape quotes and wrap quotes? I've been googling and finding all kinds of info on quotes, but nothing on fixing my comma issue.

thanks!

Excel CSVs and commas in text

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,