Split the string into 2 or 3 as required.

Question

Hi,

I have one input to summarise tool where column has 20 email ids.
I am concatenating all the email with , separator. When I am using that concatenated column in email tool, the email tool sends the email to ids present in first 255 characters. Rest is truncated.

I am looking to split the string to multiple strings each less than the length of 255 characters. But all the email ids to be included and should be complete.

Any solution is of much help.

Thanks!

LordNeilLord · Accepted Answer

Hey @TarunDeep

This is a fun little challenge!

I approached this by splitting the email addresses back in to individual rows, then using a series of multi-row formulas to "group" the emails back together based on the sum of their length. Finally a quick summarize to concat the emails back in to single cells (but multiple rows).

Which gives an output like this:

jrgo · Accepted Answer

@TarunDeep

In my opinion, the better solution would be to create an active directory distro list and where Alteryx only has to ever point to one email address. If that's not feasible, here's a possible solution for you to consider. Note that I tested this to limit to 50 characters, which is defined in the first Multi-Row formula tool.

OllieClarke · Accepted Answer

Hi @TarunDeep this is what I came up with: