- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi,
Right it's an xml field. From here it gets a bit messy:
- Select that col into the temp table and filter on @id > 0 (gets whole table minus 0 row)
- 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
- Use a js activity to read the temp table, updating the 0 col's value to 1 if (@content + '').length > 160
- Use a split activity to collect the 1's
Thanks,
-Jon