Forum Discussion

vaibhav_j's avatar
vaibhav_j
Cloud Apps
11-04-2022

Parsing variable length string

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"]