cancel
Showing results for 
Search instead for 
Did you mean: 

Parsing variable length string

vaibhav_j
9 - Travel Pro
9 - Travel Pro

I am working with a column in my EC data model which is a variable length string delimited by commas. Here are a couple examples: I would like to separate out (flatten) the string to extract the individual elements from it.  What is the best way to accomplish this? Any help/insights are greatly appreciated. Thanks! 

Example 1:

["Guaranteed Minimum Withdrawal For Life Benefit","Guaranteed Minimum Withdrawal For Life Benefit", "Surrender Charge","Surrender Charge", "Guaranteed Minimum Withdrawal For Life Benefit","Guaranteed Minimum Withdrawal For Life Benefit","Death Benefit","Death Benefit"]

Example 2:
["Death Benefit","Surrender Charge"]

0 REPLIES 0
Community Toolbox

Recommended links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]