File Browse and Action Tool to update file path but force sheet name

[KyleF]

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 |

[KSowers]

Hey Kyle,

Give this a shot and let me know if it works!

[ChrisTX]

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

[KyleF]

Would you then use dynamic input to pull the actual data?

[Felipe_Ribeir0]

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')

 

[ChrisTX]

Without RegEx, yes use Dynamic Input after you have your new full path.

Chris