Hi,
using the file wizard to load a .txt file, I am able to create a new column with the values I need, the field @10.
The script generated by the wizard is:
LOAD @1,
@2,
@3,
@4,
@5,
@6,
@7,
@8,
@9,
@10
FROM
[Journals2011.TXT]
(txt, codepage is 1252, no labels, delimiter is ';', msq, header is 13 lines, filters(
ColXtr(1, RowCnd(CellValue, 1, StrCnd(start, '!JOURNAL')), 0),
Replace(10, top, StrCnd(null))
));
It seems to work without errors but the resulting table has the tenth field empty . Why?
I attached the print screen of the wizard and the table visor.