6 Replies Latest reply: May 9, 2012 10:29 AM by jonathan dienst RSS

Problem with Filelist

Michael Kühn

I'm trying to extract some information from a filelist created with the 'for each Datei in filelist' statement.

The table TempFolder is created and the field 'QVDPathName' contains the complete path and the filename

with the extension.

 

If I try to extract the simple filename with the FileBaseName function, I'm getting only a blank field.

The 'QVDCreateTime' function works properly!

 

    for each Datei in filelist('$(vPath)' & 'QDatei*.QVD')

        TempFolder:

        Load

            '$(Datei)' as QVDPathName

        Autogenerate 1;

        Folder:

        Load

            FileBaseName(QVDPathName) as QVDName,

            QvdCreateTime(QVDPathName) as QVDDatum

        resident TempFolder;

     next

 

Any ideas, where the problem is?

 

Michael