To any formula ninjas,
A column has multiple keywords/values. I need to add a pre-fix before each of the values.
values: White, Black, Blue
To: add the prefix “Colour_” to each one of the values in the colour
I can see you have been searching for a solution on this… did you find any alternatives so far?
I have +100s of product descriptions which are completely unusable when exported into shopify, being squashed into one big paragraph.