Data getting Truncated at Text input tool

[sanketkatoch05]

Hi, when giving data to the Text input tool through a different data source via the analytical app, the field is getting truncated. How can get the full data back?

FYI, the I'm giving the Text input Tool is a big distribution list for Email tool 'To' recipient. There are around 20 IDs that are ';' separated. The Text tool field size is showing as 458.

[Maskell_Rascal]

@sanketkatoch05 - are you uploading a file for this app when you run it, or is the data built into the app and you select/deselect the recipients via the list box tool? 

[Maskell_Rascal · Accepted solution]

@sanketkatoch05 - I think I have it sorted now. 

Your List Box tool should be configured as follows:

This will create a concatenated list of your emails separated by a semicolon.

Your Update Value tool should be configured to replace the specific string like this:

That will feed into the text input as you had it previously setup. 

Then add in a Text to Columns tool to split the data to rows and feed it into your email tool. 

Attached is a mockup where I connected it to a browse tool to see the output. 

Results:

Let me know if that works for you.

Cheers!

Phil

[sanketkatoch05]

Thanks, @Maskell_Rascal.

Your solution has worked well for me. Appreciate the prompt response. 

[sanketkatoch05]

Yes, @atcodedog05, I have asked my manager to make a DL for all the recipients. Not sure when it'll be completed. Until then I'm gonna use @Maskell_Rascal's solution. 🙂