Picking up last two specific files, for transfer

06-27-2018

Registered User

456, 3

Join Date: Oct 2011

Last Activity: 20 May 2020, 8:20 AM EDT

Posts: 456

Thanks Given: 110

Thanked 3 Times in 3 Posts

Hi Don!

I tried the code outside the script just like this:

Code:

ls -1rt *Deposit_*    | tail -1
Deposit_699.checksum

and

Code:

ls -1rt *Withdrawal_* | tail -1
Withdrawal_700.checksum

It should not pick the .checksum extension files only the .csv files.

---------- Post updated at 07:32 AM ---------- Previous update was at 07:13 AM ----------

Hi

my original script was:

Code:

#!/bin/sh
HOST=192.168.6.25
USER=rico
PASSWD=123xyz
/usr/bin/ftp -inv <<EOF
open $HOST
user $USER $PASSWD
binary
cd /home/scripts/Live deposits/input
put *Deposit_* | tail -1
cd /home/script/Live withdrawal/input
put *Withdrawal_* | tail -1
bye
EOF

which gave the following output

Code:

-rw-r--r--   1 fundamo  fundamo     3723 Jan  1 00:00 Withdrawal_625.csv

which is wrong because the file I want is last Withdrawal_700.csv

Now using the code suggested by a forum member:

Code:

#!/bin/sh

# Determine files first
D_file=$(ls -1 *Deposit_* | tail -1)
W_file=$(ls -1 *Withdrawal_* | tail -1)

# Call the FTP
HOST=192.168.6.25
USER=rico
PASSWD=123xyz
/usr/bin/ftp -inv $HOST <<EOF
user $USER $PASSWD
binary
cd /home/scripts/Live deposits/input
put "$D_file"
cd /home/script/Live withdrawal/input
put "$W_file"
bye
EOF

It gives me the following results:

Code:

./teste.sh: syntax error at line 4: `D_file=$' unexpected

fretagi

View Public Profile for fretagi

Find all posts by fretagi

06-27-2018

Registered User

474, 160

Join Date: Feb 2011

Last Activity: 22 May 2020, 9:47 AM EDT

Posts: 474

Thanks Given: 51

Thanked 160 Times in 135 Posts

Quote:

Originally Posted by fretagi

Hi Don!

I tried the code outside the script just like this:

Code:

ls -1rt *Deposit_*    | tail -1
Deposit_699.checksum

and

Code:

ls -1rt *Withdrawal_* | tail -1
Withdrawal_700.checksum

It should not pick the .checksum extension files only the .csv files.

So filter for csv files:

Code:

ls -1t *Deposit_*.csv | head -1
ls -1t *Withdrawal_*.csv | head -1

and personally I'm in favour of using head over tail (imagine your directory has 300 files in it ...)

Quote:

Hi

Now using the code suggested by a forum member:

Code:

#!/bin/sh

# Determine files first
D_file=$(ls -1 *Deposit_* | tail -1)
W_file=$(ls -1 *Withdrawal_* | tail -1)

# Call the FTP
HOST=192.168.6.25
USER=rico
PASSWD=123xyz
/usr/bin/ftp -inv $HOST <<EOF
user $USER $PASSWD
binary
cd /home/scripts/Live deposits/input
put "$D_file"
cd /home/script/Live withdrawal/input
put "$W_file"
bye
EOF

It gives me the following results:

Code:

./teste.sh: syntax error at line 4: `D_file=$' unexpected

Your version of /bin/sh does not recognise the more modern process substitution syntax:

Code:

D_file=$(ls -1 *Deposit_* | tail -1)

You could either modify the "shebang" line at the top of your script to use ksh if you have it, or bash, or alternatively use the older process substitution syntax using backticks:

Code:

D_file=`ls -1 *Deposit_* | tail -1`

Andrew

These 2 Users Gave Thanks to apmcd47 For This Post:

apmcd47

View Public Profile for apmcd47

Find all posts by apmcd47

Shell Programming and Scripting

Picking up last two specific files, for transfer

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Picking up files conditionally

Discussion started by: Saanvi1

2. Linux

How to transfer files...

Discussion started by: billcrosby

3. UNIX for Dummies Questions & Answers

Sorting files based on timestamp and picking the latest file

Discussion started by: robertbrown624

4. Shell Programming and Scripting

Urgent ...pls Sorting files based on timestamp and picking the latest file

Discussion started by: robertbrown624

5. Shell Programming and Scripting

Transfer Of Files

Discussion started by: vinay123

6. Shell Programming and Scripting

Copying specific files from remote m/c to specific folders

Discussion started by: jhoomsharabi

7. UNIX for Dummies Questions & Answers

How to transfer files

Discussion started by: pankaj001np

8. UNIX for Dummies Questions & Answers

How to transfer files

Discussion started by: spoonman

9. Shell Programming and Scripting

transfer of specific file content to another file

Discussion started by: mem101

10. UNIX for Advanced & Expert Users

How do i transfer files

Discussion started by: phsoft