Shell Programming and Scripting

Hi,

I have a remote server from where i have to sftp 4 files.
Say today is 03/09/2011. Then i will recevie file with extension *_03082011.txt today

i.e i will receive today, files with yesterday's date.

And on monday i will get files with date of friday.

I am currently using mget *.* which is pulling all older files.

I tried using

Code:

sftp xyz@abc
cd directory
 ls -altr | tail 
 
ls -altr | tail -4 says invalid command.

Looks like ls -altr | tail -4 will not work in sftp session.

I need help on how to pick the last 4 files.

-------------------------------------------------------------------

2nd Issue:

Once this files are ftped from remote server to local server.

Out of these 4 files one file will contain details of the number of records in the other 3 files. And we need to use this file for reconcilation purpose.


The format is as follows:
How do i implement this.

Appreciate help.

Setup a batchfile with ls -atr in it. Now:

Code:

filelist=$(sftp -b myscript  user@host | tail -4)

To load record counts:

Code:

awk -F\| 'FNR==1 {k=$2 ~ "Number of records"; next} k {print $1,$2}' $filelist | while read file count
do
    .... your code deals with $file and $count here [eg testing $(wc -l $file) -eq  $count ]
done