Regex to capture below format data

[Ashwini008]

Hi ,

please help me with regex expression to capture the data in below part which is in bold and underlined.

e+o.in_zpiystoc.stkdrtyini.600.1.txt.1.yyyymmddhhmmss
e+o.drlugrbuyhe.xml.1.yyyymmddhhmmss
k+d.zpiyxery.npoudatri.600.gpg.1.20210127014546.gpg

i need to ignore the starting x+y values and capture only the data present before dateformat and ignore everything after date(including date).

[scelikok]

Hi @Ashwini008,

Please try below;

| rex "\.(?<filename>.+)\.\d{14}"

[manjunathmeti]

Try this:

| rex \.(?<filename>.+\.\w+\.1)

[Ashwini008]

@manjunathmeti This isn't applied to my other format files like below

c+d.zptumike.ccapd1fo.600.2.20210127020002.gpg

e+0.in_zpiyintl.truntaxi.600.1.txt.5.20210127020002.gpg

can you help with regex which applies to all the mentioned format?

[manjunathmeti]

Try this:

| rex "\.(?<filename>.+\.\w+\.\d)\."