topic Take string off of the name of workflow. in Alteryx Designer Desktop Discussions

Take string off of the name of workflow.

hlee36 — Wed, 02 Aug 2023 17:31:04 GMT

How can I take a string off of the name of workflow?

I am building something that I roll over each month, let's say.

For example, I have this workflow named "Workflow 2023.1"

I need to utilize the string 2023.1 in the workflow so it's more dynamic so that I don't have to change the workflow for each month.

I do this in Excel with formulas like

=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)

Is there a way to do this in Alteryx?

Re: Take string off of the name of workflow.

PhilipMannering — Wed, 02 Aug 2023 17:40:25 GMT

Something like this?

Re: Take string off of the name of workflow.

Felipe_Ribeir0 — Wed, 02 Aug 2023 17:40:57 GMT

Hi @hlee36

You can get the workflow name using [Engine.WorkflowFileName] inside of a formula tool. After that, you can use string formulas/regex to parse whatever you need.