Dynamic String Replace

Hi Alumio,

Kind of often we get a case where we’d like to dynamically replace a piece of a string.

The case we had today:
“Change the SKU into the new SKU. The new SKU is basically the old SKU, but change the “series code” component in the SKU to the new “series code” component (available in the dataset).”

So for example SKU is “10001-001-XL” and the new “series code component” is “002”. The old “series code component” would be “001”.

What would be great, is if we could use the PCRE Replace mapper like this:
Search: /^([0-9]{5}-)([0-9]{3})(.*)$/
Replace: $1&{newSeriesCode}$3

Another case I had is where I needed to dynamically change URLs that were in a string (HTML formatted). I had no other choice than going for the Code Transformer. But it’d be great if it was possible natively.

Hi @floris,

Thank you for your insightful forum post! You’ve brought up a great topic that highlights a real area for potential improvement in Alumio.

As you mentioned, there currently isn’t a native feature that handles this easily. While it is possible using a few steps—especially if the pattern is consistent like “XXXXX-YYY-ZZ”—the code transformer remains the most efficient approach at this time.

That said, your feedback is truly valuable, and we agree that this could be a great addition to Alumio. We’ll be forwarding this to our development team as a feature request for further consideration.

Would you prefer to be kept posted on any updates regarding this feature request?

Thanks again for sharing your thoughts and helping us improve!

1 Like