Digital Exchange

 View Only
last person joined: 3 days ago 

This community is a place to discuss Blue Prism DX assets and development.

  • 1.  syntax for locating a file with today's date in blue prism

    Posted 09-21-2019 12:01

    I want Blue Prism to email a file that is created with today's date. I am putting in a 'check if file exists' using the file management object. When I put in the file path, i am having trouble with the syntax that will look for the file with today's date.

    I have tried today(), format(Now mm.dd.yyyy) etc. I appreciate any help you can provide.

    Disclaimer: This content was auto-posted from Stackoverflow. The original Stackoverflow question is here Stackoverflow Post, posted by lucie.

  • 2.  RE: syntax for locating a file with today's date in blue prism
    Best Answer

    Posted 09-22-2019 13:16
    Hi Lucie,

    Thank you for using Blue Prism.

    If I understand exactly what you want to do is effectively search in the filename for todays date. What you would need to do is construct a data item that has today's date in exactly the format that it appears in your filename. This will be dependent on your culture settings to get this correct. However, if you look in a decision stage, you have the function InStr. This will look at a string and provide a response if a substring is found within it.

    An example of this is as follows.

    Lets say we have a text data item called MyFilename that contain "My_Filename_20190922.txt"

    We want to find the text "20190922"

    So, using InStr(MyFIlename,"20190922") would return a value of 13 as this is where the text we want to find starts in our data item.

    I hope this covers what you are trying to accomplish.

    Please come back to the forum if you need anything further.


    Geoff Hirst
    Partner Pre Sales
    Blue Prism

Welcome to the Blue Prism Digital Exchange Community!

The Blue Prism Digital Exchange is a "shop window" for new and emerging technologies—a platform that puts powerful RPA and AI capabilities into the hands of business leaders. Users can find and apply pre-built AI capabilities, in the form of downloadable integrations and Visual Business Objects (VBOs), to automated processes. These assets connect and integrate Digital Workers, existing systems and processes to Blue Prism's technology partners, creating a solid foundation of AI-enabled Intelligent Automation that's scalable and sustainable.

Blue Prism Digital ExchangeDX Asset IdeasContact DX Support


The Blue Prism Digital Exchange (DX) is an online marketplace where businesses can instantly access, apply and share pre-built AI, cognitive and advanced RPA technologies from best-in-class providers. These assets easily connect to existing digital workers, systems and processes to enhance automation capabilities.
The Digital Exchange is free to all users. Most of the content on the DX is free to download but there are some submissions that do have a cost associated. The submissions with a cost are advertised on the asset card and profile. No unwanted costs will be applied to any users.
You can visit and browse the Digital Exchange here. If you would like to consume or download any material it is necessary to create an account on the Blue Prism Portal first.
Everyone can access the Digital Exchange and consume the assets on it. If you would like to contribute to the marketplace it is necessary that you create an account and sign up as a partner.