<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Searching for Files that have an unknown timestamp using wildcard function? in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Searching-for-Files-that-have-an-unknown-timestamp-using/m-p/84510#M35638</link>
    <description>Hi,

I'm wondering if it's possible to use wildcards within a filepath search. For example as part of a 'Open File' action in the filepath name.

Detail Below;

We're currently having some difficulty with an excel file. For a process we populate our queue using&amp;nbsp;a document that is provided to us by our MI team daily.
&amp;nbsp;

The file sits within the same folder and always follows the same format, however due to a timestamp we are unable to create any logic to get the name as the report isn't always done at the same time.

FilePath; 

\\u-dom1.u-ssi.net\DFSRoot05539\TEAM\Customer_Service\Process_Automation\01 Delivery\Daily Task Extracts\Test Queue\MI Data\task_data_20180320032255_D1

We are able to use calculation stages to create the date aspect however we are unable to accurately guess the timestamp.

&amp;nbsp;

Currently we use the following method;

Data Item with initial value of;&amp;nbsp; \\u-dom1.u-ssi.net\DFSRoot05539\TEAM\Customer_Service\Process_Automation\01 Delivery\Daily Task Extracts\Test Queue\MI Data\task_data_

Multicalculation that will;

Get Today's Date.

Format Date.

Remove Strokes.

&amp;nbsp;

This then takes us a file path of; \\u-dom1.u-ssi.net\DFSRoot05539\TEAM\Customer_Service\Process_Automation\01 Delivery\Daily Task Extracts\Test Queue\MI Data\task_data_20180320

&amp;nbsp;

Can we utlise a wildcard method to say the file path is

\\u-dom1.u-ssi.net\DFSRoot05539\TEAM\Customer_Service\Process_Automation\01 Delivery\Daily Task Extracts\Test Queue\MI Data\task_data_20180320 &amp;amp;"******" &amp;amp; "_D1"

&amp;nbsp;

If this is unclear then apologies.

&amp;nbsp;

My question is ultimately summarised in

&amp;nbsp;

'Can I use wildcards within a filepath search?'

&amp;nbsp;</description>
    <pubDate>Tue, 20 Mar 2018 15:19:00 GMT</pubDate>
    <dc:creator>DeclanKeeton</dc:creator>
    <dc:date>2018-03-20T15:19:00Z</dc:date>
    <item>
      <title>Searching for Files that have an unknown timestamp using wildcard function?</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Searching-for-Files-that-have-an-unknown-timestamp-using/m-p/84510#M35638</link>
      <description>Hi,

I'm wondering if it's possible to use wildcards within a filepath search. For example as part of a 'Open File' action in the filepath name.

Detail Below;

We're currently having some difficulty with an excel file. For a process we populate our queue using&amp;nbsp;a document that is provided to us by our MI team daily.
&amp;nbsp;

The file sits within the same folder and always follows the same format, however due to a timestamp we are unable to create any logic to get the name as the report isn't always done at the same time.

FilePath; 

\\u-dom1.u-ssi.net\DFSRoot05539\TEAM\Customer_Service\Process_Automation\01 Delivery\Daily Task Extracts\Test Queue\MI Data\task_data_20180320032255_D1

We are able to use calculation stages to create the date aspect however we are unable to accurately guess the timestamp.

&amp;nbsp;

Currently we use the following method;

Data Item with initial value of;&amp;nbsp; \\u-dom1.u-ssi.net\DFSRoot05539\TEAM\Customer_Service\Process_Automation\01 Delivery\Daily Task Extracts\Test Queue\MI Data\task_data_

Multicalculation that will;

Get Today's Date.

Format Date.

Remove Strokes.

&amp;nbsp;

This then takes us a file path of; \\u-dom1.u-ssi.net\DFSRoot05539\TEAM\Customer_Service\Process_Automation\01 Delivery\Daily Task Extracts\Test Queue\MI Data\task_data_20180320

&amp;nbsp;

Can we utlise a wildcard method to say the file path is

\\u-dom1.u-ssi.net\DFSRoot05539\TEAM\Customer_Service\Process_Automation\01 Delivery\Daily Task Extracts\Test Queue\MI Data\task_data_20180320 &amp;amp;"******" &amp;amp; "_D1"

&amp;nbsp;

If this is unclear then apologies.

&amp;nbsp;

My question is ultimately summarised in

&amp;nbsp;

'Can I use wildcards within a filepath search?'

&amp;nbsp;</description>
      <pubDate>Tue, 20 Mar 2018 15:19:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Searching-for-Files-that-have-an-unknown-timestamp-using/m-p/84510#M35638</guid>
      <dc:creator>DeclanKeeton</dc:creator>
      <dc:date>2018-03-20T15:19:00Z</dc:date>
    </item>
    <item>
      <title>Can you not just use the Get…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Searching-for-Files-that-have-an-unknown-timestamp-using/m-p/84511#M35639</link>
      <description>Can you not just use the Get Files action of the file utility object, with the Folder input as \\u-dom1...etc ...\MI Data\ and task_data_*.xlsx as the File Pattern input?</description>
      <pubDate>Tue, 20 Mar 2018 15:47:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Searching-for-Files-that-have-an-unknown-timestamp-using/m-p/84511#M35639</guid>
      <dc:creator>John__Carter</dc:creator>
      <dc:date>2018-03-20T15:47:00Z</dc:date>
    </item>
    <item>
      <title>Hi John,…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Searching-for-Files-that-have-an-unknown-timestamp-using/m-p/84512#M35640</link>
      <description>Hi John,
&amp;nbsp;
That's exactly&amp;nbsp;what I went for actually, can't believe I didn't think to do it sooner.
&amp;nbsp;Pulled all the files back and then I was able to loop through the resultant collection looking for today's date. This then feeds into a separate process that will open the data and do the next stages of the process.
&amp;nbsp;
Thank you very much!
&amp;nbsp;</description>
      <pubDate>Tue, 20 Mar 2018 18:57:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Searching-for-Files-that-have-an-unknown-timestamp-using/m-p/84512#M35640</guid>
      <dc:creator>DeclanKeeton</dc:creator>
      <dc:date>2018-03-20T18:57:00Z</dc:date>
    </item>
  </channel>
</rss>

