Split function in Rules Engine, Data Designer and Query Builder

Hi team,

I think if we can have a split function that can be used to dynamically split up a string based on some delimiters like comma, space, etc, then it would be beneficial to us. 

For example,

Lets say we have 2 columns in our dataset that contains a list of product IDs and names as:
1, 2, 3, 4,….
abc, def, ghi, jkl and many more

Using this function, we can split this into a list of different products and IDs into a tabular structure and use it in reports if required.