Delphi ActiveX

CSV - Convert Comma to Semicolon Separators

See more CSV Examples

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.

Delphi ActiveX

uses
    Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants, System.Classes, Vcl.Graphics,
    Vcl.Controls, Vcl.Forms, Vcl.Dialogs, Vcl.StdCtrls, Chilkat_TLB;

...

procedure TForm1.Button1Click(Sender: TObject);
var
success: Integer;
csv: TChilkatCsv;

begin
success := 0;

csv := TChilkatCsv.Create(Self);

success := csv.LoadFile2('qa_data/csv/csv_wit_comma_separators.csv','utf-8');
if (success = 0) then
  begin
    Memo1.Lines.Add(csv.LastErrorText);
    Exit;
  end;

// 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 := ';';

Memo1.Lines.Add(csv.SaveToString());
end;