I would like request DOMO technical team to provide an Delimiter option in order to split the column data into multiple columns. A predefined function wherein we provide the delimiters which may be of different like '_' or "-" or "&" or " " etc. Giving the user an option to enter the multiple delimiters as per their data availability will provide an scope to split the column into multiples as per the conveince of the user.
Example : -
1. Area Sales Manager - Australia - Talent Pool
2. Brand Manager - New Zealand - Talent Pool (1)
3. Marketing Analyst - Malaysia - Talent Community and so on....