Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
29-07-20 03:42 PM
Long time listener, first time caller
I'm working on an automation where i need to retrieve an excel file as a collection. The problem is the file name changes as the last part is populated by the date and time of creation by the business area eg. 'MonthlyOutputReport_02012020_0711'
Is there a way i can search for the file and use some kind of wildcard for the time stamp after the date?
Alternatively is it possible to return all the file name from a directory into a collection?
Any help appreciated.
------------------------------
Robert
------------------------------
I'm working on an automation where i need to retrieve an excel file as a collection. The problem is the file name changes as the last part is populated by the date and time of creation by the business area eg. 'MonthlyOutputReport_02012020_0711'
Is there a way i can search for the file and use some kind of wildcard for the time stamp after the date?
Alternatively is it possible to return all the file name from a directory into a collection?
Any help appreciated.
------------------------------
Robert
------------------------------
Answered! Go to Answer.
1 BEST ANSWER
Helpful Answers
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
29-07-20 03:51 PM
Hi Robert,
you can use the "Utility - File Management" VBO included in the BP installation folder ("Blue Prism Automate\VBO") to retrieve the files from a folder into a collection (specifically you can use the action "Get Files").
------------------------------
Luca Valente
Senior Product Consultant
Blue Prism
America/New_York
------------------------------
you can use the "Utility - File Management" VBO included in the BP installation folder ("Blue Prism Automate\VBO") to retrieve the files from a folder into a collection (specifically you can use the action "Get Files").
------------------------------
Luca Valente
Senior Product Consultant
Blue Prism
America/New_York
------------------------------
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
29-07-20 03:51 PM
Hi Robert,
you can use the "Utility - File Management" VBO included in the BP installation folder ("Blue Prism Automate\VBO") to retrieve the files from a folder into a collection (specifically you can use the action "Get Files").
------------------------------
Luca Valente
Senior Product Consultant
Blue Prism
America/New_York
------------------------------
you can use the "Utility - File Management" VBO included in the BP installation folder ("Blue Prism Automate\VBO") to retrieve the files from a folder into a collection (specifically you can use the action "Get Files").
------------------------------
Luca Valente
Senior Product Consultant
Blue Prism
America/New_York
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-08-20 07:31 AM
Hi Robert
You can use the "Get Files" action within the "Utility - File Management" VBO. In the "Patterns CSV" input you can use a wildcard for the timestamp after the date.
This will ensure you only retrieve the specific file.
------------------------------
Nicolaas G Swart
Advisory - PI
EY Namibia
Africa/Windhoek
------------------------------
You can use the "Get Files" action within the "Utility - File Management" VBO. In the "Patterns CSV" input you can use a wildcard for the timestamp after the date.
This will ensure you only retrieve the specific file.
------------------------------
Nicolaas G Swart
Advisory - PI
EY Namibia
Africa/Windhoek
------------------------------
![](/skins/images/54F4EFCE64C1A620A51377EF9ADF6C5F/responsive_peak/images/icon_anonymous_message.png)