Load Field from the file name

[renjithpl]

I have a question.

is it possible to take excel file name as a field.

Actually i have lot of files coming in daily basis. i need a field called "Date" where the date column should read from the file name.

eg. file names (12/02/2009, 1203/2009, . . . .n times)

* I know how to load data from multiple xls files.

Please help me...

[#2]

Hi Ranjith,

You can use Filename() or Filebasename() function to get the file name of the excels.

-Peterson

[renjithpl]

HI Kevin,

its working fine, but the problem is, my file name will be in this format (12-Nov-2009).

I just want to change the same file name into 'MM-DD-YYYY' format.

I used the below formula, but its not working properly:

Date

(Filebasename(), 'MM-DD-YYYY') as Date, //this is the formula...

LOAD

[#4]

Hi,

You can use below code.

Date(Date#(FileBaseName(),'DD-MMM-YYYY'),'MM-DD-YYYY') as Date, // Untested Code

-Peterson

[renjithpl · Accepted solution]

Awesome !!!! Thanks a lot. 🙂