'Find the length of an array / comma separated string values in Quicksight Calculated Field

I have a column of sent_to_emails in my Quicksight Dataset. I want to calculate the number of values in this comma separated string i.e. split the string based on a delimiter and then calculate the number of values returned in array. Like;

"[email protected],[email protected],[email protected]" should return 3

I've searched a couple of string functions that are supported in AWS Quicksight but nothing is supporting the required results.

arraysstringamazon-quicksightcalculated-field


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions