File Browse Tool and using hardcoded sheet name and data area from a input tool.

Question

Hi all,

Wondering if there is a simple answer to the problem i am encountering in my workflow.

I am looking to use a file browse tool to specify the file name of an input which i would like to use within my input tool to transform data across multiple tabs.

I am looking to achieve an app where the file extension is updated based on the users selection, but the file browse tool will not ask for the sheet name, it will instead use the sheet name dictated in my input tool along with the prespecified data area. Is this possible? Or does anyone have any advice?

Thanks in advance,

Kane

ChrisTX · Answer

For "use a formula tool to update the file name and extension", try the Replace function in a Formula tool.

Chris

Garabujo7 · Answer

Yes indeed.

Gabriel

KaneHenderson97 · Answer

Hi @garabujo7,

Thanks for your reply! Is there a particular function to use in the formula too?

Thanks again,

Kane