Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello,
i get a file every hour in on my shared drive with the name as follows:
qppxg6dy3oqo_2021-09-09T130000_8fd9627ba6f33235446f8fcb88ca7891_c3575d
the name of the file remains the same except for the date and time which changes every hour. Is there a way to extract this information from name of file by using any Talend component?
so the output should be
date : 2021-09-09 OR 20210909
time: 13 or 1300
Hello,
You could use tFileProperties. The tfileProperties extracts certain metatadata of the files for example the basename. Using a regular expresion you could control what to extract in the next steps to produce your desired output.
Regards
@tornilleiro: thanks. i will check on this.