For\If Else logic

Help
1

Hi guys,

I have several files in a folder, suppose ABC_IN_2020 & ABC_DE_2020. IN & DE being country codes. Now there is another folder from which i need to pick a file depending on the country codes. For IN there will be two files: IN_INR_2020 & IN_EUR_2020. For DE there will be only one file DE_EUR_2020.
Now I need to pick up only 1 file from the other folder: For IN i need to pick the file with local currency(INR) & in case there is no local currency file present I need to pick the file with EUR.
Any idea how to do it?

2

Hi @sayanghosh333 ,

Try with regex, it will help you out.:innocent: