Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sushantk19
Creator
Creator

Reading the date and time from name of the file

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

Labels (3)
2 Replies
tornilleiro
Contributor III
Contributor III

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.

 

0695b00000Ie4LyAAJ.pngRegards

 

 

sushantk19
Creator
Creator
Author

@tornilleiro: thanks. i will check on this.