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.
Hi - looking for some help using regex to extract the file name and sheet name in the full path below. The folders will always change so needs to be dynamic. Thought this would be something I could find in the community but wasn't able to.
The directory tool can help you with it, just enter the folder path and it will change the results every time. If you want just to change it to output one filename you can always sort and sample the workflow.
It gives you all the information needed, including path and file name:
Use then the regex tool as in the regex description