I am getting a text file every Monday on windows server 2008. When it is uploaded, the text file will be showing a date on its name as well as in the description (time and date of loading the file on windows system). I need to capture the date either on the name (For example - xyx_011612.txt.) or from the description.
This date has to be captured in a DI column. SYSDATE function will capture only the date of run rather than the date of file.
Appreciate your help.