The get method does not do wildcard expansion, which is why "*_3rdParty.csv" does not work.

Unfortunately, Net::FTP doesn't have an mget command/method (like many system ftp tools), so you'd have to roll one yourself. Something like this (untested):

    $ftp->get($_) for grep /_3rdParty\.csv$/, $ftp->ls();
[download]

Thanks almet for ftp idea. Same, I got inputs from the node http://www.perlmonks.org/?node_id=539261 for SFTP. I got the files what i need from the directory using $sftp->ls.

my %args = (user => encode("iso-8859-1", $ftp_user) , password => enco
+de("iso-8859-1", $ftp_passwd));
        $args{ssh_args}  = [ port => encode("iso-8859-1", $ftp_port) ]
+ if $ftp_port;
        $sftp = Net::SFTP->new($ftp_url, %args);
        return 0 if (!$sftp);
        $sftp->ls($ftp_additional_path, sub { my $ref = shift;
                                              if ($ref->{'filename'} =
+~ /_3rdParty_/) {
                                                  $files->{$ref->{'fil
+ename'}} = 1
                                            }
        });
        print (keys %{$files});
        
        $sftp->get(encode("iso-8859-1", $ftp_file), $local_file);
        my ($statuscode, $statustext) = $sftp->status;
        $log->error("\nFile not found") if($statustext ne "No error");
[download]

use File::Spec;
use Net::SFTP::Foreign;

my %args = (user => encode("iso-8859-1", $ftp_user),
            password => encode("iso-8859-1", $ftp_passwd),
            fs_encoding => "iso-8591-1");
$args{port} = encode("iso-8859-1", $ftp_port) if defined $ftp_port;
$sftp = Net::SFTP::Foreign->new($ftp_url);
$sftp->error and die "unable to connect ro remote host: " . $sftp->err
+or;

my @files = $sftp->glob($ftp_file, names_only => 1);
$sftp->error and die "unable to glob: " . $sftp->error;

for my $file (@files) {
  $file =~ m|([^/]+)$| or die "bad remote file name '$file'";
  my $local = File::Spec->catfile($local_file, $1);
  $sftp->get($file, $local);
  $sftp->error and die "file transfer failed: " . $sftp->error;
}
[download]

And now...

use Net::SFTP::Foreign;

# BTW, setting your locale correctly would probably
# make these "encode" operations unnecessary!
my %args = (user => encode("iso-8859-1", $ftp_user),
            password => encode("iso-8859-1", $ftp_passwd),
            fs_encoding => "iso-8591-1");
$args{port} = encode("iso-8859-1", $ftp_port) if defined $ftp_port;
$sftp = Net::SFTP::Foreign->new($ftp_url);
$sftp->error and die "unable to connect ro remote host: " . $sftp->err
+or;

$sftp->mget($ftp_file, $local,
             on_error => sub { warn "error: " . $_[0]->error });
[download]