Count number of regex matches in a Attachment Collection

Help Studio
, , , ,
1

Hi Everyone,

I need help to count number of regex matches in attachment collection based on filename. I do have the pattern which is .(?i)^(\d{12})_(A|B|C)(.)$ but I don’t know how to check every attachment names if it followed this pattern using Linq maybe and not using for each.

Thank you in advance.

2

Hi @ppr sorry for tagging again. Do you have idea for this. Thank you :smiley:

3

Hi @mnlatam

Try this

Let’s say attachment collection is attachments

Now see the below code

attachments.AsEnumerable().Where(Function (e) System.Text.RegularExpressions.Regex.Matches(e.Name.ToString,regexpattern).Count<>0).Count

This will give the count of FileName matching regex pattern

Regards

Nived N :robot:

Happy Automation

1 Like
4

Hey @mnlatam

Try using write line to review the results:
INSERTxYOURxREGEXxRESULTxHERE.Count

Then use an IF condition accordingly.

Or

Check here for more info:

1 Like
5

Hi @NIVED_NAMBIAR ,

This code works for me. :smiley:
One more thing I might also need to get the matching file names. How will I be able to select the matching names only and I want it to store it in a list? Thanks!

6

Hi @mnlatam
Just modify the above code itself

file_list=attachments.AsEnumerable().Where(Function (e) System.Text.RegularExpressions.Regex.Matches(e.Name.ToString,regexpattern).Count<>0).ToArray()

here file_list is String

Regards,
Nived N

1 Like
7

@mnlatam

Did this work around ?

If yes kindly mark the appropriate answer as solution

Regards

Nived N :robot:

Happy Automation

8

Yes I did get it and works perfect. Many thanks guys!! :grinning:

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.