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???

Hi,

I suggest that use dbload utility.

Gustavo.