Classic ASP

CSV - Convert Comma to Semicolon Separators

Load a CSV using comma delimiters and convert to a CSV using semicolon delimiters.

Note: This example requires Chilkat v9.5.0.89 or greater.

Chilkat Classic ASP Downloads

Classic ASP

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

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

success = csv.LoadFile2("qa_data/csv/csv_wit_comma_separators.csv","utf-8")
If (success = 0) Then
    Response.Write "<pre>" & Server.HTMLEncode( csv.LastErrorText) & "</pre>"
    Response.End
End If

' Note: Prior to Chilkat v9.5.0.89, setting the Delimiter property did not modify the already-existing
' rows in the CSV.  Updating the Delimiter property in Chilkat v9.5.0.89 or greater will cause
' all rows to be updated with the new delimiter.
csv.Delimiter = ";"

Response.Write "<pre>" & Server.HTMLEncode( csv.SaveToString()) & "</pre>"

%>
</body>
</html>