Please enable JavaScript to use regex101
/
^
r
e
g
e
x
[
\
-
_
]
?
1
0
1
$
/
i
Reg
ular
Ex
pressions
101
Upgrade to Pro
Enterprise
Regular Expression
/
(?:\.([0-9]{8})\.)
/
gm
Input 1
1
New
insert into TEST values('path/to/file/OVERALL_GOTO_Datas.20201123.dat'); insert into TEST values('path/to/file/endartstmov20201124.20201124.dat'); insert into TEST values('path/to/file/TESTDEV20201123.20201123.5.0014.CHK.dat'); insert into TEST values('path/to/file/DEVTOTES20201124.20201124.5.0109.CHK.dat'); insert into TEST values('path/to/file/STORE_PARTNER.20201124.20201124.0.0501.CHK.dat');
Extraction
insert into TEST values('path/to/file/OVERALL_GOTO_Datas.20201123.dat'); insert into TEST values('path/to/file/endartstmov20201124.20201124.dat'); insert into TEST values('path/to/file/TESTDEV20201123.20201123.5.0014.CHK.dat'); insert into TEST values('path/to/file/DEVTOTES20201124.20201124.5.0109.CHK.dat'); insert into TEST values('path/to/file/STORE_PARTNER.20201124.20201124.0.0501.CHK.dat');