Allow delimiter selection when writing to multi-select picklists in Rules Engine

By default, we can only write to multi-select picklist fields successfully using semicolon-delimited string values. However, when integrating data from external systems or from CSV files, oftentimes we receive the data as comma-delimited. It would be wonderful if there was some day to do either of the following in HRE:

1. In your Action step, when mapping to an MSPL field, select delimiter type from a dropdown
2. Build some kind of custom formula or action in Transformation step of Data Setup to allow you to convert string fields based on delimiters - maybe using the logic behind “Split text to columns” and then using a “Concatenate” formula, similar to how we would do this in Excel or GSheets

Option 1 seems like the most straightforward way to solve for this issue, but I’m open to any alternative solutions that achieve the same result - being able to write to MSPLs from strings that are delimited by something other than a semicolon.

EDITING TO ADD: There are some other great suggestions for improving MSPL functionality as well that I want to highlight here since they’re related but not exactly the same:

• Writing to Multi-select Picklist in Rules Engine (Tag field and others) Development
• 62 Votes

• [Feature Request]Increase Functionality for Setting & Clearing Multi-select Picklist New Idea
• 18 Votes