Substring Function in Magic ETL
There should be a feature to do the typical substring manipulation in Magic ETL. For example, I have had multiple instances where we have a date that is formatted as a string such as '20150101'. There is no easy way in Magic ETL to call out that the first 4 characters are the year, the 2 characters starting at the 5th index in the string are month, and the last two characters are day.
In another example, let's say we have a string of City and State something like 'Seattle, Washington' or 'Salt Lake City, Utah'. There should be function that could return all the substring from the beginning to the first sign of a comma so we could separate the city and a function to grab everything from the beginning of the comma to the end of the string.
Basically, we would just need the functionality of a substring(), substring_index(), and char_index() type of a function.
See this Stack Overflow for example of SQL code you might need for this:
- 10.7K All Categories
- 13 Getting Started in the Community
- 41 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 503 APIs
- 120 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board