This is a shell scrip to download a file from an sftp server with password. File names might be with datetime stamp like FileName_2022030125600.CSV. The script will get to the sftp site, download the files with current datetime stamp to your preferred location.
set now [clock seconds] set date [clock format $now -format (%Y%m%d}] spawn sftp tp user@server-name:/path/to/file expect "Password:" send "password-here\n" expect "sftp>" send "get filename_$date* /path/to/whereto/downloadFile\n" expect "sftp>" send "exit\n"
You can save the script as sftp-download.ksh, then call it from wherever you’re as ./sftp-download.ksh