unit uConvert;
interface
uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls;
type
  TForm1 = class(TForm)
    Memo1: TMemo;
    Button1: TButton;
    Memo2: TMemo;
    Button2: TButton;
    Button3: TButton;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;
var
  Form1: TForm1;
implementation
uses StrUtils;
{$R *.dfm}
{ berfungsi untuk memecah satu baris teks menjadi beberapa bagian berdasarkan
  delimeter yang diberikan }
procedure Split(const Delimiter: Char; Input: string;
    const Strings: TStrings) ;
begin
   Assert(Assigned(Strings)) ;
   Input := AnsiReplaceStr(Input,' ','_');
   Strings.Clear;
   Strings.Delimiter := Delimiter;
   Strings.DelimitedText := Input;
end;
procedure TForm1.Button1Click(Sender: TObject);
const
  nItem = 3;
var
  lList: TStringList;
  nCount, i, j : integer;
begin
  lList := TStringList.Create;
  nCount := Memo1.Lines.Count;
  try
    for i:=0 to nCount - 1 do begin
      Split(';',Memo1.Lines.Strings[i],lList);
      for j:=0 to nItem - 1 do begin
        lList[j] := AnsiReplaceStr(lList[j],'_',' ');
      end;
      Memo2.Lines.Append('INSERT INTO nm_tabel(field1, field2, field3) VALUES '+
        '('+QuotedStr(lList[0])+', '+QuotedStr(lList[1])+', '+QuotedStr(lList[2])+')');
    end;
  finally
    lList.Free;
  end;
end;
procedure TForm1.Button2Click(Sender: TObject);
begin
  Memo1.Lines.LoadFromFile('c:\test.txt');
end;
procedure TForm1.Button3Click(Sender: TObject);
begin
  Memo1.Lines.SaveToFile('c:\test.txt');
end;
end.