How to remove remote file older than X days in SFTP

ssuthagar · Posted: Thu Jun 04, 2020 6:26 am

Hi Seniors.

I need to issue the sftp command to remove the multiple files in Unix server which are older than 30 days from Mainframes.

I am using below command

cd /file path/

rm *csv<30D

but this commands throws an error " there is no such file or directory.

When I tried issuing below command

rm *.csv <30D

it removes all the files irrespective of older than 30 days.

Can someone please help me how to achieve this.

Thanks in advance,
Suthagar

Joerg.Findeisen · Posted: Thu Jun 04, 2020 10:56 am

As sftp is not a shell or remote file manager, I don't think it's feasible this way.

Nic Clouston · Posted: Thu Jun 04, 2020 1:16 pm

Surely you want >30D?

enrico-sorichetti · Posted: Thu Jun 04, 2020 2:15 pm

surely You might want to read the manual
or use the man command to look at the help pages

the < and > in the whatever shell You are using are the redirection operators for stdin and stdout

for the rm command the < operator does NOTHING
rm does not read from stdin

the > operator will write the stdout of whatever command You issued to the file specified after the >

TESTED and VERIFIED that ...
using sftp the < and > do nothing
in bash and zsh the behavior is as described

TESTED and VERIFIED before posting ( as I always do

)

enrico-sorichetti · Posted: Thu Jun 04, 2020 2:48 pm

anywahy we cannot provide any proper soulution because we do not know about the TS setup
( specifically authorization ad ssh capabilities )

the usual way would be to use the find command with the proper selection criteria

something like ...

ssh the target system with the proper credentials

cd to the working directory

find . -type f -name "*.csv" '... the date and time selection arguments...' -exec rm {} \;

I expect the TS be able to look at the man page for the find command and determine the proper date time selection format