Excelfilename in script editor

[paulcalvet]

Hi,

I want to extract and store the excel file name from many Excel Files wich are in a folder.

DIRECTORY '$(vs_Source_Data)\budget';
FOR EACH ExcelFile in FileList('*2013_09*.xls')
BUDGET:
        Load
        KeepChar(left(@2,18),'0123456789') as Compte,
        @3 as Budget_2013
        $(ExcelFile) as Dossier,
FROM $(ExcelFile)
(biff, no labels, header is 6 lines, table is [Controle DC 200$]);

NEXT ExcelFile;

There is an error on the Excel File in the load section and i can't use this variable.

Do you know how to use this filename in the load section ?

Thanks

[paulcalvet · Accepted solution]

Hi i find the answer :

load

subfield(Filename(),'.',1) as [BranchFromFilename],

Results

By