Reading the date and time from name of the file

[sushantk19]

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

[tornilleiro]

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

[sushantk19]

@tornilleiro: thanks. i will check on this.