This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to create an application in designer which allows users to scan a folder for any excel files that have a specific sheet, however I am having a bit of trouble using the update value with formula.
Wondering how I would create a formula in the action tool that would take an input of:
The idea is that we want the beginning (Left) of the string, and to find the last "\" character, reverse the string and FindString( will locate the "first" one. Once the original is cut down to what we need, we can add the +"*.xlsx" to the end.