Output filepath only (without filename or sheet name)

[bh1789]

if I have an output path in this format:

folder\folder\folder\folder\folder\filename|||sheet name

and I want to leave off the filename and sheet name so that I can send a link (via email) to the folder where the file resides and the link would look like this

"\server\folder\folder\folder\folder\folder"

can someone tell me what tool would be best and how I would do that

Thank you!

[SPetrie · Accepted solution]

In a formula tool, you can use FileGetDir([Path]) and it will strip file names out and leave with you with just the main path.

[bh1789]

soooo easy!  thank you very much!