(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.
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<%
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Csv")
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>
|
