Sample code for 30+ languages & platforms
Classic ASP

CSV Enable Quotes

Explains the EnableQuotes property for the CSV class.

Chilkat Classic ASP Downloads

Classic ASP
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<%
success = 0

'  The CSV in this example contains this:   test;"123;abc";xyz

set csv = Server.CreateObject("Chilkat.Csv")

'  EnableQuotes is 1 by default, but we'll explicitly set to 1 here:
csv.EnableQuotes = 1
success = csv.LoadFile("qa_data/csv/enableQuotes.csv")

'  Show row 0, column 0
Response.Write "<pre>" & Server.HTMLEncode( csv.GetCell(0,0)) & "</pre>"
'  Show row 0, column 1
Response.Write "<pre>" & Server.HTMLEncode( csv.GetCell(0,1)) & "</pre>"
'  Show row 0, column 2
Response.Write "<pre>" & Server.HTMLEncode( csv.GetCell(0,2)) & "</pre>"

'  Output is: 
'   test
'   123;abc
'   xyz

'  -------------------------------------------
'  Turn off EnableQuotes and see what happens:

set csv2 = Server.CreateObject("Chilkat.Csv")
csv2.EnableQuotes = 0

success = csv2.LoadFile("qa_data/csv/enableQuotes.csv")

Response.Write "<pre>" & Server.HTMLEncode( csv2.GetCell(0,0)) & "</pre>"
Response.Write "<pre>" & Server.HTMLEncode( csv2.GetCell(0,1)) & "</pre>"
Response.Write "<pre>" & Server.HTMLEncode( csv2.GetCell(0,2)) & "</pre>"
Response.Write "<pre>" & Server.HTMLEncode( csv2.GetCell(0,3)) & "</pre>"

'  Output is:

'   test
'   "123
'   abc"
'   xyz

%>
</body>
</html>