I am creating an app where I want the user to be able to use the file browse to select a file path, but then force the sheet name that is input regardless of their selection. I believe I've seen it done with update value with formula, but I don't remember the regex formula to replace the current things left of | with the path data left of |
If you want to avoid RegEx, you can use functions like FileGetDir, FileGetFileName, FileGetExt to separate the folder, file name, and extension.
And a Text to Columns tool, using | as the delimiter to get the Sheet name
Then rebuild the full path you want from the existing fields.
Here's a list of all functions: Functions | Alteryx Help
Chris
Would you then use dynamic input to pull the actual data?
Hi @KyleF
You can use this formula inside your action tool, just replace the Sheet1 by the Sheetname that you want to always be imported
REGEX_Replace([#1], '(?<=\|\|\|)(.*?)$', 'Sheet1')
Without RegEx, yes use Dynamic Input after you have your new full path.
Chris