Hello,
The problem I have is that we have unique strings that represent a product of ours. For each line of products, we have different colors that change the 'suffix' of the unique string. For example, Product A's base string is AA123, and depending on the color, it will have a different suffix such as a blue Product A is AA123XY and a red Product A is AA123ZT.
The issue is all colors of the product are mashed at the end of the base part, separated by a backslash. My goal is to have a unique string for each of the base part - color combinations so we can easily join these unique strings to other datasets within our company.
I've gotten as far as parsing by the delimiter(backslash) but I'm hoping someone can help me develop a workflow on sticking the suffix's back on to the base string. The trickly part is that not every suffix is the same length of character. Example of before/after state is below and thank you for your help!
@BrooksGrebin
Is you " unique strings" has a fixed length?
Hello, @BrooksGrebin.
I believe the attached workflow solves this problem. There will need to be edits if the base string is not 5 characters. Perhaps you can review and let us know? Hope this helps.