Alteryx Character Counter

[Richie059]

Hey guys, thanks in advance for the help. 

So, I would like to cap the character count to 34 for the [Payer Name 1]. and move the rest of the data to [payer name 2]. But, we need to separate the data at the last space before the last word. So in this example, The output were looking for is [Payer Name 1] = "Made up company for Alteryx" and [Payer Name 2] = "Community. I Can't figure this out and would really be thankful for the help

[binu_acs]

@Richie059 Are you looking for some thing like the below?

[Luke_C]

Hi @Richie059 

Here's an approach to check the character count and update accordingly. I split the words into rows and create a running total. You may need to tweak the logic if Payer Name 2 needs to be truncated due to it's own character limits, which I presume is similar if this is 1099 data.