Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006
    Posts
    14

    Unanswered: Import text file with 4gl

    Hi,

    I have to import a text file into a table. The problem is the text file, it looks like this: The number and order of the fields (F1, F2, ...) are always different.

    #FILE;date;
    #VERSION $..$
    #DEF;DATA;F1;F2;F3;F6;
    01;01;01;01;
    02;02;02;02;
    #END;
    #FILE;date;
    #VERSION $..$
    #DEF;DATA;F1;F4;F5;F7;F8;
    11;11;11;11;11;
    12;12;12;12;12;
    13;13;13;13;13;
    #END;
    #FILE;date;
    #VERSION $..$
    #DEF;DATA;F1;F3;F5;F6;
    31;31;31;31;
    #END;

    The table should look like this:
    F1 F2 F3 F4 F5 F6 F7 F8
    01 01 01 01
    02 02 02 02
    11 11 11 11 11
    12 12 12 12 12
    13 13 13 13 13
    31 31 31 31

    Is this possible with 4gl??? Does anyone have an idea???

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,

    I suggest that use dbload utility.

    Gustavo.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •