get file date as column value
Posted: Mon Apr 10, 2017 9:49 pm
Hi,
I have a scenario like source file include date like ABCD10112016.dat . I need to derive that file date value '10112016' for one of the target field.
Could you help how to reach, Moreover will get multiple files same day with different dates.
1job source files:
ABCD09112016.dat
ABCD10112016.dat
ABCD11112016.dat
ABCD12112016.dat
ABCD13112016.dat
2job source files:
EFGH09112016.dat
EFGH10112016.dat
EFGH11112016.dat
EFGH12112016.dat
EFGH13112016.dat
I have a scenario like source file include date like ABCD10112016.dat . I need to derive that file date value '10112016' for one of the target field.
Could you help how to reach, Moreover will get multiple files same day with different dates.
1job source files:
ABCD09112016.dat
ABCD10112016.dat
ABCD11112016.dat
ABCD12112016.dat
ABCD13112016.dat
2job source files:
EFGH09112016.dat
EFGH10112016.dat
EFGH11112016.dat
EFGH12112016.dat
EFGH13112016.dat