Convert Text Input into comma separated text to then update 4 in database connection value

Question

I have a workflow that the user selects how they want to run the report.  Either by TIN, PIN or NPI.  Depending on their selection one of three different workflows run.

Currently it is set up to just accept 1 input via a text interface tool.  That then passes through an update tool to update the text in the formula for an in database connection.

I now need to update the workflow and change the text interface tool to a multi line.  I then need to take that and convert it to comma separated to then pass through to the action tool.

I know how to convert the text list however I don't know how to pass that through to the update tool. The last part of the conversion is a summary tool and I don't know how to connect that to an update tool

Any suggestions?

Robin_McIntosh · Answer

We'll touch base later but high level, here's some steps you'll need to do.

1 - Set the Text Box (interface) to Multiline
2 - Send the entries (Action) to a Text Input (single field)
3 - Use Text to Columns (Split to Rows) with delimiter of 
 (can indicate comma or \s as well just in case user inputs differently)
4 - Then join back/filter to the Input or update formula, etc.

cowannbell · Answer

I don't want to make the user enter each one with a comma.

Robin_McIntosh · Answer

@cowannbell Don't want to do what?