Shell Programming and Scripting

Hello,

I have a UNIX script to sftp batch processing. Here is my sftp command.

Code:

ftp -b toopc userid@sftp.hostname.com

In the file toopc I have the following commands:

Code:

mget *.csv
bye

This brings in all files with an extension of .csv

However, I need to only bring in files that

1. start with "435_193_"
2. todays date in year month day format
3. .csv extension.

example 435_193_20140611.csv

I have been having trouble figuring out the get command for this to work. Everything I try gets an error.

Please help.

John Schlinz

Moderator's Comments:

Please use code tags next time for your code and data. Thanks

correcting your line mget *.csv to

Code:

 mget 435_193_*20140611.csv

produces an error?

Thanks VBE. The example may not be very clear. I will need to replace the hard coded date shown in example with a date function to get current date each time it runs. Something like this: mget 435_193_'date +%Y%m%d'.csv

So you place the date value in a variable:

Code:

WANTEDDT=$(date +%Y%m%d)

and you use it after:

Code:

mget 435_193_*$WANTEDDT.csv

Hell vbe,

The variable set up works. However, it doesn't seem to be read correctly in command file. This is message I get.

Couldn't stat remote file: No such file or directory
File "435_193_$WANTEDDT.csv" not found.

Thanks.

You need to call sftp not ftp for a start.

You may need to re-create the batch file in your shell script each time you run. Consider this:-

Code:

#!/bin/ksh

echo "mget *_`date%Y%m%d`" > toopc
sftp -d toopc userid@sftp.hostname.com

Does that help?



Robin

That work! Thank you both very much.