Hello Community! Looking for help with Regex expression. I tried to figure out how to parse one column with three values delimited by a comma and mixed in each row. Example: ProductDescriptionOneMeasures:10/10/10, Material: Steel, Color: BlackTwoMaterial: Steel, Measures:10/10/10, Color: BlackThreeColor: Black, Measures:10/10/10, Material: SteelFourMeasures:10/10/10, Material: Steel, Color: BlackFiveMaterial: Steel, Measures:10/10/10, Color: BlackSixColor: Black, Measures:10/10/10, Material: SteelSevenMeasures:10/10/10, Material: Steel, Color: BlackEightMaterial: Steel, Measures:10/10/10, Color: BlackNineColor: Black, Measures:10/10/10, Material: SteelTenMeasures:10/10/10, Material: Steel, Color: Black What I want: ProductDescriptionMeasuresMaterialColourOneMeasures:10/10/10, Material: Steel, Color: Black10/10/10SteelBlackTwoMaterial: Steel, Measures:10/10/10, Color: Black10/10/10SteelBlackThreeColor: Black, Measures:10/10/10, Material: Steel10/10/10SteelBlackFourMeasures:10/10/10, Material: Steel, Color: Black10/10/10SteelBlackFiveMaterial: Steel, Measures:10/10/10, Color: Black10/10/10SteelBlackSixColor: Black, Measures:10/10/10, Material: Steel10/10/10SteelBlackSevenMeasures:10/10/10, Material: Steel, Color: Black10/10/10SteelBlackEightMaterial: Steel, Measures:10/10/10, Color: Black10/10/10SteelBlackNineColor: Black, Measures:10/10/10, Material: Steel10/10/10SteelBlackTenMeasures:10/10/10, Material: Steel, Color: Black10/10/10SteelBlack If you need more information please let me know. Thanks a lot for any hints or solutions.

Regex – Parse one column with different values delimited by a comma

Hello Community!

Looking for help with Regex expression.

I tried to figure out how to parse one column with three values delimited by a comma and mixed in each row.

Example:

What I want: