New Idea
Split Function in Bionic Rule Transformation Task
It would be great if there was a split function added to the capabilities of a transformation task within a bionic rule.
I have a situation where I am trying to parse the information from a field that contains multiple comma-separated values. For example, the data for a given record may look like this: "Phoenix,Seattle,Los Angeles"
Using the Right and Left function, I am currently only able to isolate the values "Phoenix" and "Los Angeles".
Introducing a Split function, or something similar, would allow users to specify the separating character, a comma in my example, and could output the data above into three different fields.
I have a situation where I am trying to parse the information from a field that contains multiple comma-separated values. For example, the data for a given record may look like this: "Phoenix,Seattle,Los Angeles"
Using the Right and Left function, I am currently only able to isolate the values "Phoenix" and "Los Angeles".
Introducing a Split function, or something similar, would allow users to specify the separating character, a comma in my example, and could output the data above into three different fields.