Using File name wild card

Help Studio
1

“D:\UiPath\JE\JE Entry\Property\Albany Homes\08.23\ALBANY HOMES - Workpapers.xlsx”

workpapers only in common in filename

this ALBANY HOMES - will change every time

suggest me the best wild card

2

could look like this:

"D:\UiPath\JE\JE Entry\Property\Albany Homes\08.23\*Workpapers.xlsx"

Unfortunately the request is not complete clear e.g

  • From what is the wildcarded path consumed
  • Folder in Between Property\xxx\08.23 - we would assume that there also some dynamics will be needed

Can you elaborate more about your case please? Thanks

3

Excel Application Scope: Failed opening the Excel file file:///D:/UiPath/JE/JE%20Entry/Property/Albany%20Homes/08.23/*Workpapers.xlsx. Possible reasons: the file is corrupt, the file is already used by another process or you don’t have permissions to open the file.

4

Hi @SURESH_P

You can use this * wildcard.

"D:\UiPath\JE\JE Entry\Property\Albany Homes\08.23\*Workpapers.xlsx"

The workpapers is same I have replaced the Albany homes with wildcard.

Hope it helps!!

5

Hi @SURESH_P

You can use this below syntax:

D:\UiPath\JE\JE Entry\Property\Albany Homes\08.23\* - Workpapers.xlsx

Hope it helps!!

6

Excel Application Scope: Failed opening the Excel file file:///D:/UiPath/JE/JE%20Entry/Property/Albany%20Homes/08.23/*%20-%20Workpapers.xlsx. Possible reasons: the file is corrupt, the file is already used by another process or you don’t have permissions to open the file.

7

Make sure to close the excel before you run the workflow. And sure your file path is correct. @SURESH_P

Regards

8

All files are closed

9

As the scope is more about to handle a single file we would recommend:

  • us wildcarded path for collecting all possible files with Filesystem relatred options like
    DirectoryInfo… / Directory.GetFiles(…)

then loop and process over the found files item wise

10

Is there a possiblity to replace single character? In my case I need to make sure its in certain length Numeric