Pascal (Lazarus/Delphi)

CSV Column Names

See more CSV Examples

Demonstrates how to access CSV column names.

The Chilkat CSV library/component/class is freeware. The downloads for .NET, C++, Perl, Java, Ruby, and Python contain all of the Chilkat classes, some of which are freeware and some of which require licensing.

Pascal (Lazarus/Delphi)

program ChilkatDemo;

// Demonstrates using the Chilkat Pascal wrapper via the C bridge DLL.
// Builds as a console application under Lazarus (FPC) or Delphi.

{$IFDEF FPC}
  {$MODE DELPHI}
{$ENDIF}
{$APPTYPE CONSOLE}

uses
  {$IFDEF UNIX}
  cthreads,
  {$ENDIF}
  SysUtils,
  CkDllLoader,
  Chilkat.Csv;

// ---------------------------------------------------------------------------

procedure RunDemo;
var
  success: Boolean;
  csv: TCsv;
  i: Integer;
  colName: string;
  idx: Integer;

begin
  success := False;

  //  This example program loads a file (sample.csv)
  //  that contains this content:
  //  
  //  year,color,country,food
  //  2001,red,France,cheese
  //  2005,blue,"United States",hamburger
  //  2008,green,Italy,pasta
  //  1998,orange,Japan,sushi
  //  
  //  The first row contains the column names.
  //  This file is available at:
  //  http://www.chilkatsoft.com/testData/sample.csv

  csv := TCsv.Create;

  //  Prior to loading the CSV file, indicate that the 1st row
  //  should be treated as column names:
  csv.HasColumnNames := True;

  //  Load the CSV records from the file:

  success := csv.LoadFile('sample.csv');
  if (success <> True) then
    begin
      WriteLn(csv.LastErrorText);
      Exit;
    end;

  //  Display the column names:

  for i := 0 to csv.NumColumns - 1 do
    begin
      colName := csv.GetColumnName(i);
      WriteLn(i + ': ' + colName);

      //  The following line demonstrates to to get the column
      //  index given a column name:
      idx := csv.GetIndex(colName);
      WriteLn(colName + ' is at column index ' + idx);
    end;



  csv.Free;

end;

// ---------------------------------------------------------------------------

begin

  try
    RunDemo;
  except
    on E: Exception do
      WriteLn('Unhandled exception: ', E.ClassName, ': ', E.Message);
  end;

  WriteLn;
  {$IFDEF MSWINDOWS}
  WriteLn('Press Enter to exit...');
  ReadLn;
  {$ENDIF}
end.