topic Use of FileName in script in QlikView

Use of FileName in script

Thu, 02 Jan 2014 09:11:00 GMT

Hi all,

I have a loop in a dir with FoundFile param which get's a full path with file name into it.

I try to get only the file name, but when I use:

let vTemp3 = filename('$(FoundFile)');

I get NULL in vTemp3.

but in this : let vTemp= '$(FoundFile)';

I get the correct path.

I tried to remove the single quotes, didn't help.

regards,

Boris

Anonymous — Thu, 02 Jan 2014 09:39:49 GMT

Hi,

You might try something like below.

LET vTemp3 = SubField('$(FoundFile)', '\', -1);

Regards,

Aadil

Siva_Sankar — Thu, 02 Jan 2014 09:48:40 GMT

Hi,

Try this,

Sub DoDir (Root)

For Each Ext In 'qvd' // filetype to search for in current directory

For Each File In FileList (Root & '\*.' & Ext)

Files:

Load '$(File)' as WayToFile,

FileTime('$(File)') as FileTime,

Replace(Mid('$(File)',Index('$(File)','\', SubStringCount('$(File)','\'))+1),'.$(Ext)','') AS FileName,

Autogenerate 1;

Next File

Next Ext

For Each Dir In DirList (Root & '\*') // searching in subdirs

Call DoDir (Dir)

Next Dir

End Sub

Regards.

Siva