By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE #Temp (
BLOB_NM VARCHAR(100)
);
INSERT INTO #Temp
SELECT 'products_country_20200528102030.txt'
UNION ALL
SELECT 'products_territory_20190528102030.txt'
UNION ALL
SELECT 'products_country_2020-05-20_20200528102030.txt'
;
3 rows affected
select blob_nm, substring(blob_nm, len(blob_nm) - 17, 14) res from #temp
| blob_nm | res |
|---|---|
| products_country_20200528102030.txt | 20200528102030 |
| products_territory_20190528102030.txt | 20190528102030 |
| products_country_2020-05-20_20200528102030.txt | 20200528102030 |