Alteryx Character Counter

Question

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

Luke_C · Answer

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.

New Workflow3.yxmd

binu_acs · Answer

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

Regex_0912.yxmd