topic Re: File delete in Talend Studio

File delete

lmit — Tue, 03 Mar 2020 09:09:52 GMT

Hi All,

I have a zip files with dates as file name so i have to delete the files which are 5 days older to current date, how can i achieve this, i tried tfileproperties component from the forum which uses file creation date

is there a way where i can use file name date for deletion?

Thanks in advance,

lmit

Re: File delete

TRF — Tue, 03 Mar 2020 09:34:08 GMT

Into a tJava component, use TalendDate.addDate to get the current date minus 5 days and TalendDate.formatDate to format the result as expected and store the result to a global variable:

globalMap.put("theDate", TalendDate.formatDate("yyyyMMdd", TalendDate.addDate(TalendDate.getCurrentDate(), -5,"dd")));

Then, use a tFileList component to get all file with the desired mask:

Finally, use tFileDelete to all corresponding files.

Re: File delete

lmit — Tue, 03 Mar 2020 11:44:11 GMT

Hi All,

Thanks TRF for your suggestion i did as your suggested but only one file is getting deleted not the other files which are greater than 5.

It should all the zip files which are greater than 5 days

Thanks,

lmit

Re: File delete

TRF — Tue, 03 Mar 2020 12:28:57 GMT

If you need to delete files older than 5 days, you need to get all files, extract the date part from the filename, convert it into a date and compare the result to the current date minus 5 days.
Here is what the job should look like:
tFileList--(iterate)-->tJava--(If)-->tFileDelete

Re: File delete

lmit — Fri, 06 Mar 2020 12:59:51 GMT

Hi TRF,

Thanks for the reply but My file names have only date , I followed the process you said but still only one file is getting deleted.

Thanks,
Lmit

Re: File delete

TRF — Fri, 06 Mar 2020 17:13:21 GMT

Share your job design with components settings and an example filename

Re: File delete

lmit — Tue, 10 Mar 2020 13:42:51 GMT

Hi TRF,

my file names will be 2020-03-10.zip

Please find the attachment for the job design.

in if link, the condition is

context.comapredate >=1

Thanks,

lmit

delete.PNG

Re: File delete

lmit — Wed, 18 Mar 2020 12:35:25 GMT

Hi all,

Any suggestions on the below

Thanks in advance,
Lmit