I have a requirement where i am getting xls file every month and file doesnt contain any date field inside. I am thinking to read the file name and populate the field for date while loading.
File name format : <abc>_<CDefg>_MMDDYYYY_HHMMSS
Many thanks in Advance!
left(subfield(FileName,'_',3),2) as Month;
Hi m w
probably I have not explained the question properly.
file name is not present inside the file.<abc>_<CDefg>_MMDDYYYY_HHMMSS
so i cannot use left(subfield(FileName,'_',3),2) as Month;
1st i have to read the excel name.
2nd extract date from file name.
3rd populate the field based on file name.
Use the FileName() function to get the name of the file.
left(subfield(FileName(),'_',3),2) as Month;
Retrieving data ...