Avatar

Community Advisor

Hi,

Right it's an xml field. From here it gets a bit messy:

  1. Select that col into the temp table and filter on @id > 0 (gets whole table minus 0 row)
  2. Add a col to the output with just the value 0, there should be at least the content col and the 0 col in the temp table
  3. Use a js activity to read the temp table, updating the 0 col's value to 1 if (@content + '').length > 160
  4. Use a split activity to collect the 1's

Thanks,

-Jon