Return Folder Name as field

[renjithpl]

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.

[#2]

Hi,

See the 'Photo and Music' sample from Start Page

subfield(FileLongName,'\',substringcount(FileLongName,'\')) as [Photo Directory]

Regards,

Andris

[#3 · Accepted solution]

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