vaibhav_j
11-04-2022Cloud Apps
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"]