Looping specific files in a folder

[Seema_Jethe]

I want to process only specific files in a folder by looping the files. The specific files are
“C:\Users\seema.jethe\Downloads\Test\PAN_3456pdf”, “C:\Users\seema.jethe\Downloads\Test\CHEQUE_2345.pdf”, “C:\Users\seema.jethe\Downloads\Test\GST_1234.pdf”
and i am storing “C:\Users\seema.jethe\Downloads\Test” in one variable. Can anyone help me with this?
Below are the screenshots

[Steven_McKeering]

Hi @Seema_Jethe

Check out this post

Looping through files

Hi James, You could get the filelist with Directory.GetFiles(string path, string searchPattern) - it supports * and ? wildcards: string() pdfList = Directory.GetFIles("D:\myFolder", “Weekly Macro Report*.pdf”) and then iterate with For/Foreach loop where you will have the ReadPDF activity. Regards.

Try inserting this into an Assign activity where:
Left Assign:
Array of String variable (String[ ])

Right Assign:
“Directory.GetFiles(“C:\Users\seema.jethe\Downloads\Test”, “.pdf”)”

It will give you a collection of all PDF files in that folder location.

Does this help you?

[Jobin_Joy]

Hi @Seema_Jethe

Is this what you are expecting?

Thank you.

[Seema_Jethe]

@Jobin_Joy yes i am expecting the same but i need regex for the ss shown below

[ppr (Peter Preuss)]

@Seema_Jethe

but i need regex for the ss shown below

start with following:

(PAN|CHEQUE|GST).*.pdf$

For further help:

[CheatSheet] VB.Net CheatSheet Catalogue

This topic references the different CheatSheets related to VB.Net It will be updated on new published CheatSheets as well. Regular Expressions - RegEx File System API About the CheatSheet Series The CheatSheet series covers various programming topics and lists selected API statements. In addition to the help given, the CheatSheets can also be used to check one’s own knowledge and to explore further development approaches. Recommendations Training courses from Academy Debugging cou…

[Sudharsan_Ka]

Hi @Seema_Jethe

You can try with this alternative

• for each file in the folder and inside you can give the condition like
  • if the folder path contains PAN or CHeque or GST

Regards
Sudharsan