“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
“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
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:
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