Find File Names in Folder with a particular name format ex : 0123_ETCD_2018_<Description>

Help
1

Experts

I have a folder where there will be 100s of files . The format that my process expect is as below . How can I read only those files in the format mentioned ?

example only files which start with : 0123_ETC9_2018_

0123 is constant
ETC9 - First 3 is alphabets and last letter is a number. It could be XYD4 , TYR4 or any combination
2018 is year

2

Hi

You can use this expression:

1 Like
3

@aviokc2011 Try below workflow. I think it is might be solution for yours.

Main.xaml (8.9 KB)

I used below files for reference. U can look also at it.
list.zip (1.3 KB)

1 Like
4

Majuts90

Thanks for this XML . In my case for example the file which has a name - 0134XYD42018_villa.txt

should error out . How do i do that ?

5

@aviokc2011 try below code
“0123[A-Z]{3}[\d]{1}2018[_][w]*”

If last pasrt only contains letters(i.e, after 2018_). U use below pattern
“0123[A-Z]{3}[\d]{1}2018[_][A-z]*”