Wildcard file path

[damonyl]

Hi all,

problem:
i wish to read a single sheet from each files with path:-

    C:\Users\user\Documents\testenviroment\test_20190715_1220.xlsx
    C:\Users\user\Documents\testenviroment\test_20190714_1420.xlsx
    C:\Users\user\Documents\testenviroment\test_20190713_1020.xlsx
    .
    .
    .
    C:\Users\user\Documents\testenviroment\test_20190715_0820.xlsx

20190715 is about yyyy,mm,dd
0820 is about time now
time now is the one i wish to wildcard, which no algorithm, or tracking part can be used to track it.

for example, in read file, with path “C:\Users\user\Documents\testenviroment\test_todayDate_*.xlsx”

to me, is failed with reason

any solution or suggestion?

[venkat4u (venkat)]

Hi @damonyl,

you can not use wildcard in file path.
what is your requirement can you elabarate much more. So we can help

[lakshman (Ganta lakshman)]

@damonyl

We can’t use wildcards in reading file.

Try this way.

    strExcelFiles [] = Directory.GetFiles("C:\Users\user\Documents\testenviroment\","test*.xlsx")

The above expression will read all matching files and will give output as string array. Then use For Each loop activity to read one by one file.

[damonyl]

@lakshman

    strExcelFiles [] = Directory.GetFiles("C:\Users\user\Documents\testenviroment\","test*.xlsx")

Hi @lakshman, so which activity should i run for this code? assign?

[lakshman (Ganta lakshman)]

@damonyl

use Assign activity and create one variable of type string array and say strExcelFiles

[damonyl]

@lakshman

use Assign activity and create one variable of type string array and say strExcelFiles

@lakshman will try this. By the way, i have update my post and more precise. please have a look

[damonyl]

@venkat4u, try check if you understand my post now. i have update the problem facing

[lakshman (Ganta lakshman)]

@damonyl

My expression will work for you and just try once.

[damonyl]

@lakshman

I’ve tried put it in assign, it turns up

[lakshman (Ganta lakshman)]

@damonyl

It should be like this:

        Directory.GetFiles("R:\Phil\DB Specifications\", ReportName.Tostring+"_"+Now.Tostring("yyyyMMdd")+"_"+"*.xlsx")

[damonyl]

@lakshman got it! thanks! so the comma will be before folder name. thanks again!