Using File name wild card

“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

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

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.

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!!

Hi @SURESH_P

You can use this below syntax:

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

Hope it helps!!

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.

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

Regards

All files are closed

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

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