This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Community
- Legacy Discussions
- Build Analytics
- Parsing variable length string
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Parsing variable length string
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-04-2022 05:02 AM
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"]
Labels:
- Labels:
-
Dashboards & Reporting
0 REPLIES 0
Community Toolbox
Recommended quick links to assist you in optimizing your community experience:
- Community FAQs
- Community Welcome & Guidelines
- Discussion Posting Tips
- Partner Guidelines
- Profile Settings
- Ranks & Badges
Developers Group:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email [email protected]
