The XLGETFILE command takes into account the LFD file, if it exists.
This file has the same name as the text file to be imported, but with the suffix "LFD".
The first line of the LFD file contains the name of the text file to import, without its extension, in brackets [].
[My file]
The following lines describe the format of each column of the text file to import. There is one line in the LFD file per column of the text file.
Format of a description line : N=Type,format
N = Column number. The first column is number 0.
Type =
Num : For a numeric type column.
Format : n.d
n= Number of digits
d= Number of decimals
Text : For a text column.
Format : n
n is the number of characters (optional)
Date : For a date column.
Format :
DMY : Day/Month/Year
MDY : Month/Day/Year
YMD : Year/Month/Day
Skip : To ignore the column, and not to import it.
Example :
[LNC002]
0=Num,5.0
1=Num,5.0
2=Date,YMD
3=Date,YMD
4=Num,5.0
5=Text,7
6=Skip
7=Text,7
8=Num,8.2