topic How to delete a file that is 5 years old. in Talend Studio

How to delete a file that is 5 years old.

_AnonymousUser — Sat, 16 Nov 2024 12:20:43 GMT

Hi,
I would like to ask help on how to delete a file that is 5 years older than its date modified.
Date Modified is in a file property
example:
If a file was created 2007 and it was last modified 2012. then this will be deleted.
Since I am not a Java man, i would like to know the script on this on tMAP or tFilterRow.
Thanks.

Re: How to delete a file that is 5 years old.

Anonymous — Tue, 28 Feb 2012 03:50:26 GMT

Hi
You can use tFilterRow and check Advanced mode.

TalendDate.compareDate(TalendDate.addDate(new Date(input_row.mtime_string),5,"yyyy"),TalendDate.getCurrentDate())==-1

tFileProperties-->tFilterRow-->tFileOutputDelimited
|
OnSubjobOk
|
tFileInputDelimited--row3-->tLogRow
|
Iterate
|
tFileDelete
Type row3.abs_path into "File Name" of tFileDelete.
Regards,
Pedro

Re: How to delete a file that is 5 years old.

_AnonymousUser — Tue, 28 Feb 2012 05:40:39 GMT

Got it! thanks pedro.