Split Function in Bionic Rule Transformation Task

I would like to re-energize this ask with an additional vote and use-case….. we receive our active product data in a semi-colon delimited list and can range from 1 - x products.  We need the flexibility to isolate active products and as well as launch onboarding for products and this is becoming a greater challenge.   Pretty please? 

Still needed. Similar scenario

While not ideal. You could do multiple transformations and take the right or left on each one.

I.E. My string is "Phoenix,Seattle,Los Angeles" and I want Phoenix.

So you take everything to the right of the first comma. “Seattle,Los Angeles” and then everything to the left of the first comma “Seattle”

I thought more about this. Depending on your use case you could also pivot for each condition/option and then sue the fields individually to determine if set condition = true or not. If you need the actual string value then this wouldn’t really help you.

The first solution doesn’t work because the Left function doesn’t store the remaining values somewhere. My string is "Phoenix,Seattle,Los Angeles" will return Phoenix but “Seattle,Los Angeles” won’t be stored anywhere to use in another transformation.

The Pivot idea requires summarization which is not the case for me here. I’ve got nothing to summarize, I just want to parse. Or as I call it reverse concatenate 

Fairly certain that is the purpose of Left/Right. Left Trim and Right Trim are suppose to keep everything once it finds a string.

However, can’t seem to get them to work properly. So came up with another work around.

You can Transform, Number position of a string, looking for comma here. Then second transformation and sub string using the Number position. Then third transformation where you Number position of a string, again looking for comma here. Then 4th transformation and sub string using the second number position.

Again, not ideal but, possible workaround.

lol.  Yep tried that one.  The problem with it is I can’t refer to a field when writing the substring formula. It requires a static number.  So I can’t refer to the number position I just calculated and stored.  I can only enter a number.  

Hmm, feel like that got changed. I’ve done this before. I know I have. I wonder if it got limited.

FYI, you cna do this in bionic rules. Everywhere else seems broken.