...
my $start = quotemeta "$file$yesterday";
my ($file) = $sftp->glob(qr/^$start\d{6}$/, names_only => 1);
...