Please help regex expresion to filter 4 numbers in filename

[Ricchch (Ricardo)]

Hello Friends,
I need your help to find a regular expression being able to filter an attachement whose name is composed by 4 numbers (begining by 4 numbers) and the extension are .xls ,csv or .xlsx

if file name is composed by letters or less than 4 numbers , the regular expression should be able to filter that.

Thanks in advance
Ricchch

[lrtetala (Lakshman Reddy)]

Hi @Ricchch

Try this

\b\d{4}\.(xlsx|xls|csv)\b

Cheers!!

[mkankatala (Mahesh Kankatala)]

Hi @Ricchch

- BoolFlag = System.Text.Regularexpressions.regex.Ismatch(Input,"^\d{4}(?=.xls|.csv|.xlsx)")

Check the below image for better understanding,

BoolFlag is the boolean variable. It will give you true if the filename is with 4 numbers and following with extensions. It will give false if the file name is less than or greater than 4 numbers and letters.

Check the below workflow, If the input is 1134.xlsx -

Check the below worflow, If the input is abcd.xls

Hope it helps!!

[Anil_G (Anil Gorthi)]

@Ricchch

I believe this is what you need

\d{4}.*\.(xlsx?|csv)

Cheers

[Ricchch (Ricardo)]

@lrtetala @Anil_G @mkankatala @indra
Thanks to all of you…!

It Works

[Ricchch (Ricardo)]

Hello Friends,
i need an extra help please.
the regex works when there is just one attachment in the email.

However , when i have more that one attachment in the email , it is not able to filter attachment respecting the rules comparing to those not respecting rules .

in other words, it can’t filter filesnames with letters and having less of 4 number when email has more than one attachment and one of them is correct and the other ones not…

Thanks for helping