Filter file started without "$"

Mateo_Drouillard · February 7, 2023, 8:59am

Hey developers,

I have actitie who read all file in folder.
I would like to filter without “$” in the name.

Do you have an idea when i could make ?

Thanks for your returns !

Gokul001 · February 7, 2023, 9:02am

Welcome to UiPath community

Can you tell us the Filename?

Regards
Gokul

Mateo_Drouillard · February 7, 2023, 9:04am

The filename can change but it’s all time .xlsx
The foldername is : “.…\Ready”

Srini84 · February 7, 2023, 9:10am

Welcome to forums

Inside for each you can put a If condtion as below

path.GetFileName(Articles.ToString).StartsWith(“$”)

Then-> means you have $ in filename starting
Else → It’s not started with $

Hope this may help you

Thanks

Gokul001 · February 7, 2023, 9:11am

You can try with Regex expression : IsMatch

Use If activity

System.Text.RegularExpressions.Regex.IsMatch("Input File","\$")

Regards
Gokul

Shikhar_Tandon · February 7, 2023, 9:13am

You can use something like

Directory.GetFiles(folderPath).Where(Function(file) Not file.Contains("$")).ToList()

this will give you the list of files without $ in them

Thanks

Mateo_Drouillard · February 7, 2023, 9:32am

i would like to take only file don’t start with “$”

Shikhar_Tandon · February 7, 2023, 9:34am

Directory.GetFiles(folderPath).Where(Function(file) Not file.StartsWith(“$”)).ToList()

you can use this as well

system · February 10, 2023, 9:35am

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