Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Filebasename() returns file name, Is there a way to get folder name like that.
I tried Filedir() but that gives the whole directory.
THanks in advance.
Hi,
try to use the following script lines:
Load *,
Subfield(Dir,'\', NumberOfTimes + 1) as FolderName;
LOAD
FileDir() as Dir,
substringcount(FileDir(),'\') as NumberOfTimes
Good luck!
Rainer
Hi,
See the 'Photo and Music' sample from Start Page
subfield(FileLongName,'\',substringcount(FileLongName,'\')) as [Photo Directory]
Regards,
Andris
Hi,
try to use the following script lines:
Load *,
Subfield(Dir,'\', NumberOfTimes + 1) as FolderName;
LOAD
FileDir() as Dir,
substringcount(FileDir(),'\') as NumberOfTimes
Good luck!
Rainer